Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 36024 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
What do you mean by teradata intelliflex?
What is a node in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the different design perspectives used in teradata?
how do you manage the production space. what are the proactive methods you can take ?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is stored procedure in teradata?
What is a level of granularity of a fact table?
Did you write stored procedures in teradata?
What are aggregate tables? How do you design them using teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What are the functions involved in shared information architecture?
Which is faster fastload or multiload?
Is multi insert ansi standard?
What is TPD?
