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
- 7100 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 is the purpose of joins in teradata and what are the available join types?
Can we collect statistics on multiple columns?
What are the newly developed features of Teradata?
What is the use of teradata system software?
What is a dimension table?
Describe the between keyword in teradata?
What is upsert statement in teradata?
What is the difference between teradata and basic rdbms?
Highlight the advantages of PPI(Partition Primary Index).
Different phases of multiload?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is meant by a Clique?
What is the purpose of joins in teradata?
How many types of joins are there in teradata?
