Interested to Buy Any Domain ? << Click Here >> for more details...
how teradata fetches a row from primary index table?
- 1 Answers
- 3796 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 |
How do you set the session mode parameters in bteq?
I want to write one query How to get Matched records and unmatched records in table?
What is stored procedure in teradata?
What exactly do you know about catching in teradata?
what is identity columns in TD?
What is multi insert?
Why AMP & PE are called Vprocs?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the various reporting tools in the market?
Explain the term 'columns' related to relational database management system?
Increasing no of amps will increase performance. Is this true?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
Teradata 
