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.