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.