Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7402 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tdguy
PI - mandatory and very important in TD. Useful in
distribution and retrieval. Performance of TD highly
depends on PI.
SI - Optional and provides alternate path to data. When
choosen appropriately, this improves the performance of
queries.
| Is This Answer Correct ? | 5 Yes | 0 No |
Difference between inner join and outer join?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
any one answer me how they can analyzing the project using data ware housing?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the 5 phases in a multiload utility?
How to copy teradata scripts from ur remote desktop to server machine?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
what is the structure of UV table in MLOAD?
What is basic teradata query language?
What is smp and mpp platforms?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
What is a level of granularity of a fact table?
Teradata 
