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 a dimension table?

1072

Explain PDE.

1085

Explain parsing engine in teradata?

1098

What are the multiload utility limitations?

1068

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

1133

What is spool space? Why do you get spool space errors?

1025

What do you mean by teradata sql assistant?

1067

What is the purpose of joins in teradata?

1192

Why is the case expression used in teradata?

1080

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

1059

What do you mean by caching in teradata?

1066

How to select first n records in teradata?

1110

What is bteq utility in teradata?

984

If a Node is busy what are the steps you can take to avoid ?

2416

How many types of joins are there in teradata?

979