Question

What are the different types of indexes in SQL?

Answer 1

SQL indexes are nothing more than a technique of minimizing the query's cost. The higher the query's cost, the worse the query's performance. The following are the different types of Indexes supported in SQL:

1. Unique Index
2. Clustered Index
3. Non-Clustered Index
4. Bit-Map Index
5. Normal Index
6. Composite Index
7. B-Tree Index
8. Function-Based Index