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
- 6903 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 meant by a Virtual Disk?
What are the functions of a Parser?
In Teradata, what is the significance of UPSERT command?
Explain the parallel data extension in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
What are the uses of client software involved in teradata?
What is stored procedure in teradata?
What is the difference between fastload and multiload? Which one is faster?
Highlight the differences between Primary Key and Primary Index.
Highlight a few of the important components of Teradata?
What is meant by a Parsing Engine?
Syntax for case when statement?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain the term 'database' related to relational database management system?
Explain parsing engine in teradata?
