|
Notices |
|
Thread Tools | Rate Thread | Display Modes |
06-01-2018, 10:09 AM | #1 |
Registered User
Join Date: Mar 2018
Posts: 341
|
What is the difference between clustered and non clustered index in SQL?
There are mainly two type of indexes in SQL, Clustered index and non clustered index. The differences between these two indexes is very important from SQL performance perspective.
One table can have only one clustered index but it can have many non clustered index.(approximately 250). clustered index determines how data is stored physically in table. Actually clustered index stores data in cluster, related data is stored together so it makes simple to retrieve data. reading from a clustered index is much faster than reading from non clustered index from the same table. clustered index sort and store data rows in the table or view based on their key value, while non cluster have a structure separate from the data row.
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|