Thread: Table Indexes

I am learning SQL. I am aware about the types of indexes in SQL. I do not have any idea about the indexers types. I have referred a lot of SQL book to know about the indexes types. But I did not get appropriate detail. Any help would be appreciated.

Following are the potential types of indexes:

1. Spatial

2. Index with included columns

3. Nonclustered

4. Indexed views

5. Clustered

6. Filtered

7. Full-text

The indexes of SQL are separated into Clustered and Non-Clustered indexes. If you want to get back from the clustered index then you require following:

• Single read for intermediate level

• Single read for index root level.

• Single read for data page.