Clustered Index
- System sorts rows on an ongoing basis so that the physical order is the same as the indexed order
- only 1 can exist per table
- should only be created for a column that is most often retrieved in order
- greatly increases performance when searching for contiguous key values… especially a range
- slows down data updates due to the sorting involved