Secondary indexes - types

Database
Junior Supporter

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

Tags (1)