Interested to Buy Any Domain ? << Click Here >> for more details...
Hi frinds pls help me regarding this question
WHY usi is two amp operation in teradata?
THANKS IN ADVANCE....
- 3 Answers
- 7225 Views
- I also Faced
- E-Mail Answers
Answer Posted / tdguy
When an USI is created, a subtable is generated and stored.
When that USI is used in the query,TD recognizes the USI.
TD will hash the SI and the hash map will point to the
subtable in one AMP. The subtable row will point the row-id
and the row is fetched from the second amp.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the enhanced features in teradata v2r5 and v2r6?
What are default access rights in teradata? What explicit right can be given to a user?
How is the teradata different from oracle?
What is logical data model?
What are normalization, first normal form, second normal form and third normal form?
What do you mean by teradata sql assistant?
What is called partitioned primary index (ppi)?
How is MLOAD Client System restarted after execution?
Explain the term 'foreign key' related to relational database management system?
Difference between stored procedure and macro?
Describe the set operators in teradata.
What is bteq script in teradata?
What is the purpose of using case expression in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are some primary characteristics of teradata?
