Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7345 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 is logical data model?
What is primary index and secondary index?
What is collect statistics?
What do you mean by teradata intellicloud?
How does hashing happens in teradata?
How is the teradata different from oracle?
How can we check the version of Teradata that we are using currently?
What is node? How many nodes and amps used in your previous project?
List out some of the primary characteristics of teradata.
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the term 'primary key' related to relational database management system?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the different functions included in the server software?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What does sleep function does in fast load?
