Types of indexes
Different types of indexes can be created for different purposes and performance benefits.
Some examples of the purposes and benefits are:
- Unique indexes enforce the constraint of uniqueness in your index keys.
- Bidirectional indexes allow for scans in both the forward and reverse directions.
- Clustered indexes can help improve the performance of queries that traverse the table in key order.
- Expression-based indexes efficiently evaluate queries with the indexed expression.