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

Dung Do Tien Oct 19 2020 273

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

Have 1 answer(s) found.
  • M

    Marry Christ Oct 19 2020

    Below is some difference between Clustered and Non-clustered in SQL Server:

    1. Clustered Index

    - Only has a clustered index in a table.

    - It's created on the primary key.

    - Data retrieval is faster than the non-cluster index.

    - Sort the records and store them physically according to the order

    - Do not need extra space to store the logical structure.

     

    2. Non-Clusted

    - Quicker for insert and update operations than a clustered index.

    - Can create many non-cluster indexes in a table,  the maximum of 999 non-clustered indexes per table as per limitations.

    - Use extra space to store the logical structure.

Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Popular Tips

X Close