The difference is that a clustered index sorts the data of the table physical so it's more efficient on columns that are searched alot or you try to get ranges of the table using this column or you sort by the column or when you have a unique column and try to get single rows of it.