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 exactly do you know about catching in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
In general, how do you optimze any sql in teradata?
What is database exceptions in teradata?
What is partitioned primary index (ppi)?
How is the teradata different from oracle?
What are aggregate tables? How do you design them using teradata?
What are the multiload utility limitations?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is basic teradata query language?
What are the various indexes in teradata? How to use them? Why are they preferred?
Define views in teradata with syntax.
What are the design features involved in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
In BTEQ, how are the session-mode parameters being set?