Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7284 Views
- Wipro, I also Faced
- E-Mail Answers
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 do you mean by teradata intellicloud?
What are the various indexes in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is oltp?
What are the different table types supported by teradata?
Explain teradata architecture?
What is the difference between fastload and multiload? Which one is faster?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is the primary index in teradata?
How is the teradata different from oracle?
Describe primary index in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is meant by a Least Cost Plan?
