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
- 7039 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
how can we analyze the locks ?
Explain the meaning of Amp?
What is database exceptions in teradata?
any one answer me how they can analyzing the project using data ware housing?
How many tables can you join in v2r5?
How many types of joins are there in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the various etl tools in the market?
Differentiate database data and data warehouse data?
What are the different design perspectives used in teradata?
What do you mean by teradata intelliflex?
Which is more efficient group by or distinct to find duplicates?
Can you fastexport a field, which is primary key by putting equality on that key?
