PI plays a very important role in teradata. It is used in data distributi

what is the difference between primary index and secondary index?.

Question Posted / tdguy

Answer Posted / tdguy

PI plays a very important role in teradata. It is used in
data distribution. Very important for joins. SI provides
alternate path for data access.

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Highlight the need for Performance Tuning.

1089

What is the use of having index on table?

985

What are the different table types that are supported by teradata?

990

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1096

What are default access rights in teradata?

1098

what is object level locking ? where do appear this type of locking ?

3475

What are the joins in teradata?

966

How do you define Teradata?

1021

What is bteq script in teradata?

1134

What is teradata and why it is used?

1074

Highlight the advantages of PPI(Partition Primary Index).

1064

What is the purpose of indexes?

1045

What do you mean by fastexport in teradata?

981

How is the teradata different from oracle?

1082

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1140