All Forums Database
teradatauser2 236 posts Joined 04/12
21 Nov 2015
Secondary indexes - types

Hi,
How many types of Secondary indexes (NUSI) are there ? I have read about the below three.
1. NUSI
2. Hash ordered NUSI
3 Value ordered NUSI
1 .When we dont give any qualifier while creating SI, then what kind of SI does it create  i.e Create Index (xxxx) on dbname.tablename ?
2. What are the different usage of these kind od indexes ?
Thanks !
Samir

You must sign in to leave a comment.