Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
Answer Posted / satish
When table is having NUSI, the sub table created by it will
be populated only by Hashing (not like Hash Re distribution
for USI), here redistribution of the records will not be
done,which will take more time generally,
As Fastload and Multiload are intended to Load the data at
fast they have taken out the USI, support so that the target
tables will be loaded very faster,
if we need we can create the SI after loading
---
If you have better ANS please Share with us
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
In the Primary Index, what is the score of AMPs that are actively involved?
How can you track login parameters of users in teradata?
How can bottlenecks be identified?
How to eliminate product joins in a teradata sql query?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the purpose of indexes?
What are default access rights in teradata?
List out all forms of LOCKS that are available in Teradata.
What is spool space? Why do you get spool space errors?
What are the various indexes in teradata?
What is the purpose of joins in teradata and what are the available join types?
how many modules are there in telecome domain?how to explain the architecture?
In BTEQ, how are the session-mode parameters being set?
What are different table types used in teradata?
Explain the term 'tables' related to relational database management system?