An Introduction to Clustered and Non-Clustered Index Data Structures
I've found a good description and samples demonstrating clustered and non-clustered indices in SQL Server.
Generally, clustered index combines index and data into a single record while non-clustered index creates index separately, which links to the data page.
Practically, clustered indices are preferred if many rows are to be retrieved and if a range of data is to be retrieved (i.e. using BETWEEN).
As usual, one of the best theoretical sources is Wikipedia. See the page on index here.
I've found a good description and samples demonstrating clustered and non-clustered indices in SQL Server.
Generally, clustered index combines index and data into a single record while non-clustered index creates index separately, which links to the data page.
Practically, clustered indices are preferred if many rows are to be retrieved and if a range of data is to be retrieved (i.e. using BETWEEN).
As usual, one of the best theoretical sources is Wikipedia. See the page on index here.
No comments:
Post a Comment