What are the types of index?

What are the types of index?

Unique indexes enforce the constraint of uniqueness in your index keys. … Expression-based indexes efficiently evaluate queries with the indexed expression. Unique and non-unique indexes. … Clustered and non-clustered indexes. … Partitioned and nonpartitioned indexes. … Bidirectional indexes. … Expression-based indexes.

See also  Why is an older car more expensive to insure?