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
- 7234 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tdguy
When an USI is created, a subtable is generated and stored.
When that USI is used in the query,TD recognizes the USI.
TD will hash the SI and the hash map will point to the
subtable in one AMP. The subtable row will point the row-id
and the row is fetched from the second amp.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / gowthami
Thanks alot nitin for ur rly.
i would like share 1 interview question which was asked in
ibm.
Q)there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.
thanks in advance
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain amp in teradata?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
What is the use of upsert command in teradata?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
wt r before journal& after journel.....in teradata
Is multi insert ansi standard?
How to view every column and the columns contained in indexes in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
what is identity columns in teradata
Highlight the points of differences between the database and user in Teradata.
Teradata 
