July 4, 2012 at 1:30 pm
Is the main difference between clustered indexes and non-clustered indexes that the clustered indexes have the entire row of its table whereas the non-clustered index has merely a pointer to the row of the table?
Why are clustered indexes called clustered? It seems like there could be a better term.
July 4, 2012 at 2:00 pm
Clustered indexes are the actual table data (hence why you can only have one clustered index per table). A nonclustered index will have key column and non key column data (through the INCLUDE clause) so the leaf nodes will contain data. That's the power of a covering nonclustered index.
As for the naming convention I can't say for sure what the origin is.
July 4, 2012 at 2:15 pm
Maybe take a read through these.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply