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

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1723

What is meant by a Channel Driver?

1141

What are the components provided on node?

984

If RDBMS is halted what will you do ?

2098

Explain the term 'database' related to relational database management system?

924

What is multi insert?

983

In Teradata, what is the significance of UPSERT command?

1127

What are the functions of a teradata dba?

1019

What are teradata utilities?

1031

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1083

In Teradata, how do we Generate Sequence?

980

List out all forms of LOCKS that are available in Teradata.

913

Define views in teradata with general syntax.

981

What are the scenarios in which full table scans occurs?

938

What are some commonly used bteq scripts?

942