The clustering index determines the physical order, while the non-clustering index is maintained separately and may contain multiple pointers to the same record.

The clustering index is always implemented as a dense index, whereas the non-clustering index is always implemented as a sparse index.

Both indexes determine the physical order of the records in the table.

The non-clustering index always results in faster query performance than the clustering index.