how teradata fetches a row from primary index table?
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 can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
What is a dimension table?
What is the use of fallback?
What is meant by a Least Cost Plan?
How to run a query in teradata?
During the Display time, how is the sequence generated by Teradata?
What is the default join strategy in Teradata???
Difference between inner join and outer join?
In Teradata, what is the significance of UPSERT command?
What is meant by Teradata Gateway?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?