![]() |
Hello All,
11 Feb 2016
| 2 comments
,
|
![]() |
Hi,
13 Dec 2014
,
|
![]() |
Hi Experts, Requirement-->
There is a table which would be having history of 24 months of data at any point of time.
03 Aug 2013
| 6 comments
,
|
![]() |
|
![]() |
It was a complex Business Objects report with some > 30 joins and instead of coming up with some sort of Join Index recommendation I Wiz is asking me to drop a bunch of NUSI's that are'nt getting used and says it will improve the system performance 15%.
06 Nov 2011
| 3 comments
,
|
![]() |
Hi, Really wonder how these indexes are different, which one to use and where to use. Any help would be greatly appreciated. Thanks.
30 Jul 2011
| 7 comments
,
|
![]() |
Hi, I am firing a explain plan query on a table (Item) in TD.The third step of the explain plan reads like: 3) We do an All-AMP RETRIEVE step from DBNAME.Item by way of index # 4 "DBNAME.Item.PartKey=328" is built locally with no resisual conditions into Spool 1 (group_amps), which is built locally on the AMPs.The size of spool 1 is.... Note: A Non-Unique Secondary Index (NUSI) is defined on ParKey column of Item table. The question is: What does index#4 mean in the explain plan.Does it refer to the NUSI?
20 Jan 2011
| 1 comment
,
|
![]() |
How are the sub tables for NUSI created? Also NUSI subtables are present in the same AMP in which the data they point to is present(Not so in case of USI ). How is this possible?
18 Jan 2011
,
|
![]() |
Suppose you have a table with several non-unique secondary indexes (NUSI). When TPump loads the table, should you expect that each row’s INSERT will cause a table level lock on each of the secondary index sub-tables? And if so, couldn’t this create a lot of blocking across sessions?
14 Dec 2009
| 2 comments
,
|