how teradata fetches a row from primary index table?
Answer Posted / vinoth
All the rows in the table will be evenly disturbed among the AMP's based on the Primary Index column.
Eg. employee table (EMP_NO(PI),EMP_NAME)
AMP1 AMP2 AMP3
12,PARTI 15,alex 14,flex
When you execute the query select emp_name from employee where emp_no='12' .
It's a One AMP operation, it will directly go to AMP 1 and it will fetch the value "PARTI".
Please look at the terms PE, BYNET and AMP to understand this more.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is spool space? Why do you get spool space errors?
Syntax for case when statement?
What is a level of granularity of a fact table?
List the logical and conditional operators that are used with teradata along with their meanings?
How many tables can you join in v2r5?
What is the primary index in teradata?
Explain teradata architecture in detail with a diagram.
Highlight the advantages of PPI(Partition Primary Index).
What is the purpose of joins in teradata and what are the available join types?
What are the components provided on node?
What does sleep function does in fast load?
How many sessions of MAX is PE capable of handling at a particular time?
What is teradata and why it is used?
what are the day to day activities of teradata DBA ?
What is meant by Teradata Gateway?