Cluster indexes

The table is stored in the sort order specified by the primary key.

-> Can be ether heap- or index-organized storage.

Some DBMSs always use a clustered index.

-> If a table doesn't contain a primary key, the DBMS will automatically make a hidden row id primary key.

Other DBMSs cannot use them at all.