Interested to Buy Any Domain ? << Click Here >> for more details...
Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 38514 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar s
MulitLoad has support for Non-Unique Secondary Indexes
(NUSIs) since NUSIs are AMP Local. They have subtable within
base table. It has no hash bucket to redirect to another
amp, everything points to their own amp (AMP Local)
If you go with USI, it has hash bucket, which might redirect
to another amp, more possibilites for full table scan.
Motive for avoiding Indexes(other thn NUSI): Avoid Full
table scan.
Regards
Rajesh Kumar S
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Can we collect statistics on table level?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is multi insert?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Highlight the differences between Primary Key and Primary Index.
Explain how spool space is used.
What do you mean by ttu in teradata?
What is a clique?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How many types of joins are there in teradata?
What are the various reporting tools in the market?
What is spool space? Why do you get spool space errors?
Explain the teradata primary index mechanics in detail with a diagram.
