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. 

 

上一篇:HTML链接式引入CSS和JS


下一篇:【Beta】Daily Scrum Meeting——Day6