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
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the advantages of teradata?
What can be achieved by using the teradata rdbms?
What exactly do you know about catching in teradata?
How do you determine the number of sessions?
Highlight the limitations of TPUMP Utility.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
how do you manage the production space. what are the proactive methods you can take ?
Which is faster fastload or multiload?
Highlight the points of differences between the database and user in Teradata.
What happens in a conflict? How do you handle that?
Explain amp in teradata?
Is multi insert ansi standard?
What are the different table types that are supported by teradata?