Interested to Buy Any Domain ? << Click Here >> for more details...
how teradata fetches a row from primary index table?
- 1 Answers
- 3740 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 |
Why Fload doesn’t support multiset table?
Explain and compare pros and cons of start schemas?
Explain fastload in teradata?
What is the use of teradata system software?
What are the different functions included in the server software?
What is the syntax for case when statement?
I want to write one query How to get Matched records and unmatched records in table?
What is TPD?
How to find duplicates in a table?
Why Multiload does not supports USI and supports NUSI?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
Teradata 
