how teradata fetches a row from primary index table?
- 1 Answers
- 3017 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What do you mean by teradata intelliflex?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
can we join volatile table with general table an global temporary table with general table ?
Differentiate primary key and partition key?
What is the difference between teradata and oracle?
How is MLOAD Client System restarted after execution?
What is the opening step in basic teradata query script?
What is primary index and secondary index?
What does sleep function does in fast load?
Why MLOAD needs Work Tables?
Can you connect multiload from ab initio?
what is use of PI(primary index) AND SI(secondary index)
Teradata 
