a Database Index that determines the organisation of the data Pages in a Database table

an index that has been physically merged with a table

a special index that forces SQL Server to store the table data in the exact order of the index

a special type of index that reorders the way records in the table are physically stored

An index in which the physical order of the data and the logical (indexed) order of the data is the same. Only one clustered index can exist on a table. See also "leaf level."

An SQL Server term for an that shares the storage of its table. A clustered is not like an Oracle cluster, but more like and Oracle IOT ( Index-Organized Table).

An index whose sequence of key values closely corresponds to the sequence of rows stored in a table. The degree to which this correspondence exists is measured by statistics that are used by the optimizer.