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
- 7228 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 difference between teradata and oracle?
What do you mean by parsing?
What are the different functions performed in development phase?
How does hashing happens in teradata?
What are the various indexes in teradata? Why are they preferred?
What is the difference between global temporary tables and volatile temporary tables?
What are the steps involved after the disk manager passes the request?
Highlight the differences between Primary Key and Primary Index.
What is teradata? Also, list out some of the primary characteristics of teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How to identify ppi columns?
What is spool space? Why do you get spool space errors?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the 5 phases in a multiload utility?
What is the use of having index on table?
