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

What is meant by a Parsing Engine?

1234

What can be achieved by using the teradata rdbms?

1087

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2087

What does sleep function does in fast load?

1207

What is difference between user and database in teradata?

1114

Can we collect statistics on table level?

1092

How many sessions of MAX is PE capable of handling at a particular time?

1135

What is basic teradata query language?

1163

List the logical and conditional operators that are used with teradata along with their meanings?

1039

What does Amp contain and what are all the operations that it performs?

1052

Explain fastload in teradata?

1144

What are the components used in smp and massively parallel processing (mpp) machines?

1093

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

1055

Define views in teradata with syntax.

1125

What are the design features involved in teradata?

1115