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. 

 

posted @ 2020-03-20 14:56  ChuckLu  阅读(136)  评论(0编辑  收藏  举报