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
- 38956 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
When it comes to secondary indexes, subtables are build by
TD.
In USI, the subtables are build on all the amps and used,
when this index is used in the query. Since, this involves
communication of amps, mload does not support usi.
In NUSI, the subtables are build within the amps and refer
to the local data of the amp. Thus, NUSI is supported by
mload, since it is amp local.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
In general, how do you optimze any sql in teradata?
Why is the case expression used in teradata?
Highlight the limitations of TPUMP Utility.
What is stored procedure in teradata?
Why managing the data is important?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What's the difference between timestamp (0) and timestamp (6)?
What are different table types used in teradata?
Explain the term 'primary key' related to relational database management system?
What is the use of fallback?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the joins in teradata and how many types of joins are there in teradata?
Describe the between keyword in teradata?
What is called partitioned primary index (ppi)?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
