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.

What are the commands to make a new table, change a table and remove a table in teradata?

1 Answers  

---

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

2 Answers   IBM,

---

Can we collect statistics on multiple columns?

1 Answers  

---

How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  

---

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

---

What are the design features involved in teradata?

1 Answers  

---

Highlight the points of differences between the database and user in Teradata.

1 Answers  

---

What are the joins in teradata and how many types of joins are there in teradata?

1 Answers  

---

How would you load a very large file in teradata in general?

1 Answers  

---

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1 Answers  

---

Which is faster fastload or multiload?

1 Answers  

---