Tuesday, September 23, 2008

Clustered and Non-Clustered Index

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.

No comments: