Generally, PI on an unique column would be recommended. This is because,

On which column will you take primary index???

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

Generally, PI on an unique column would be recommended.
This is because, the unique primary index helps TD to
distribute the row evenly among amps.

Is This Answer Correct ?

29 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the parallel data extension in teradata?

1076

What are the 5 phases in a multiload utility?

1021

Explain fastload in teradata?

1087

How do you verify a complicated sql?

1051

What are the things to be considered while creating secondary index?

1083

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2191

Explain the most common data types used in teradata?

1045

How can bottlenecks be identified?

1003

What is logical data model?

1189

What is bteq utility in teradata?

953

What is the use of fallback?

976

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1101

What are tpump utility limitations?

1109

What is the purpose of upsert command?

1153

What are aggregate tables? How do you design them using teradata?

1155