Hi frinds pls help me regarding this question
WHY usi is two amp operation in teradata?
THANKS IN ADVANCE....
- 3 Answers
- 5700 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 |
How to cast date "2015-03-03-012204-000000" to timestamp
Difference between stored procedure and macro?
What do you mean by fastexport in teradata?
Find 2 highest sal from each dept who have completed 5 year in org
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
If the table does not have duplicates then which utility you can suggest to load the data ?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Explain and compare pros and cons of start schemas?
What are the different methods ot loading a dimension table? A fact table etc?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
If table have access lock.In the same table write lock is posible or not?
Difference between star and snowflake schemas?
Teradata 
