Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7285 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 |
Is multi insert ansi standard?
What is teradata and why it is used?
In the Primary Index, what is the score of AMPs that are actively involved?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
What are the differences between TerdataV2R5 and V12 Versions please??
Explain the new features of teradata?
Can any one please provide me practical example of How to do the performance tuning in Query??
What are the uses of bynets in multi-node systems?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
how can we analyze the locks ?
Why do Hash joins usually perform better than Merge Joins?
Teradata 
