AI engineering glossary · SQL databases
What is clustered index?
Clustered index: An index that determines the physical order in which a table's rows are stored, so the table itself is the index. A table can have only one, and range scans on it are very fast. InnoDB and SQL Server use this.
Clustered index: an example
In MySQL InnoDB, the primary key is the clustered index, so rows sit on disk in primary key order.
Related terms
More SQL databases terms
- COALESCE
- Column
- COMMIT and ROLLBACK
- Common table expression
- Composite index
- Connection pool
- Correlated subquery
- Covering index
Where you learn it
Clustered index is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.