Pages

Saturday, September 21, 2013

SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index | Journey to SQL Authority with Pinal Dave

Clustered Index Only 1 allowed per table Physically rearranges the data in the table to conform to the index constraints For use on columns that are frequently searched for ranges of data For use on columns with low selectivity Non-Clustered Index Up to 249 allowed per table Creates a separate list of key values with… Continue Reading...

Source: SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index | Journey to SQL Authority with Pinal Dave