what is use of PI(primary index) AND SI(secondary index)

Answers were Sorted based on User's Feedback



what is use of PI(primary index) AND SI(secondary index)..

Answer / gowthami

The data can be access in teradata in 3ways..
1.Full table scan
2.Primary index
3.secondary index
PRIMARY INDEX:This one is Mandatory index.Teradata
distribute data across all amps.so for distribution of data
P.I need.
accessing and retrieval is possible through primary
index.which contains..1)UNIQUE PRIMARY INDEX 3)NON UNIQUE
PRIMARY INDEX 3)PARTITIONED PRIMARY INDEX 4)NO PRIMARY
INDEX(from teradta13)
SECONDARY INDEX:only retrival possibele through secondary
index.Means it doesnot distribute the data.
Using scenario::-There is a primary index on the table.But
we are using other than primary index colums in the where
clause as part of frequently retrival data.In this situation
system does full table scan,To avoid this take SI on the table.

Friends if any one have the better ans plz add.

Is This Answer Correct ?    8 Yes 0 No

what is use of PI(primary index) AND SI(secondary index)..

Answer / tdguy

PI - mandatory and very important in TD. Useful in
distribution and retrieval. Performance of TD highly
depends on PI.
SI - Optional and provides alternate path to data. When
choosen appropriately, this improves the performance of
queries.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Teradata Interview Questions

What is the opening step in basic teradata query script?

0 Answers  


How is Teradata in current market?

4 Answers  


What are the 5 phases in a multiload utility?

0 Answers  


What is smp and mpp platforms?

0 Answers  


How to find duplicates in a table?

0 Answers  






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

0 Answers  


How do you set the session mode parameters in bteq?

0 Answers  


How to identify ppi columns?

0 Answers  


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

0 Answers  


How to eliminate product joins in a teradata sql query?

0 Answers  


what is meant by Hot amp?

2 Answers   IBM, Satyam,


Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 Answers  


Categories