QUERY ON SECONDARY INDEX:
Hi Friends ,
I was new to this teradata and its related concepts .
clear my doubts for the following things ...
1.Why we use secondary index ? How S.I effects
the performance ?
2.How many Secondary indexs can be created ?
with respective to the versions ?
3.Is it possible to access the Sub-Table of a
Secondary Index ? and What type of table (ex:set
table or multiset table...etc ) is Sub-table in S.I ?
4.In which memory will the sub-table store (Temp 0r perm)?
5.What is the structure of a SET table ?
plz clarify my quries .....