Hi frinds pls help me regarding this question
WHY usi is two amp operation in teradata?
THANKS IN ADVANCE....
- 3 Answers
- 6004 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin bansal
Generally the Parsing Engine preapres a two amp plan for
USI, as in case of USI there will be a subtable which has
the hashed value of the USI and the ROW ID of the Primary
Index. So when you search using the USI first it will go to
the AMP which has the subtable and then using the ROW id
from the subtable it will go to the AMP where the actual
row resides.
In a case where the PI and USI value are same it can be a
one amp operation as the HASHED value of oth the PI and USI
will go to the same AMP.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by teradata intelliflex?
What are the functions of a Parser?
Highlight the need for Performance Tuning.
How is MLOAD Teradata Server restarted after execution?
What is bteq script in teradata?
What is a clique?
What is node? How many nodes and amps used in your previous project?
What are default access rights in teradata?
Explain teradata utilities?
What is the command in bteq to check for session settings ?
Explain the term 'columns' related to relational database management system?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the 5 phases in a multiload utility?
Can we collect statistics on multiple columns?
What do you mean by teradata sql assistant?
