Performance

Clustered Index

English

Overview

An indexing method that keeps the physical order of the stored data aligned with the index's own ordering.

Details

A table can only have one clustered index, but in exchange it offers excellent performance for range searches. Many database products automatically create a clustered index on the primary key.

More Database terms