what is use of PI(primary index) AND SI(secondary index)
Answer Posted / 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 |
Post New Answer View All Answers
What are the things to be considered while creating secondary index?
What is meant by a node?
What are the different functions included in the server software?
What are the uses of client software involved in teradata?
What is the function of parser component in teradata?
During the Display time, how is the sequence generated by Teradata?
How do you verify a complicated sql?
How to find duplicates in a table?
What is the maximum number of dml can be coded in a multiload script?
Why do you get spool space errors? How do trouble-shoot them?
Explain PDE.
What are the main components of teradata system?
What is the purpose of indexes?
What are the various indexes in teradata?
What interface is used to connect to windows based applications?