What is the difference between Clustered and Non-Clustered Indexes in SQL Server?

What is the difference between Clustered and Non-Clustered Indexes in SQL Server?

Conclusion

From the discussion we find following differences between clustered and non-clustered indexes.

1. There can be only one clustered index per table. However, you can create multiple non-clustered indexes on a single table.
2. Clustered indexes only sort tables. Therefore, they do not consume extra storage. Non-clustered indexes are stored in a separate place from the actual table claiming more storage space.
3. Clustered indexes are faster than non-clustered indexes since they don’t involve any extra lookup step. 

 

作者:Chuck Lu    GitHub