Nonclustered Indexes

The other type of relational index that can be created is a nonclustered index. Nonclustered indexes do not impose a sort order on the table, so you can create multiple nonclustered indexes on a table. Nonclustered indexes have the same restrictions as a clustered index—maximum of 900 bytes and maximum of 16 columns, along with additionally being limited to a maximum of 249 nonclustered indexes on a table.

Index Maintenance

At first glance, you might think that you should just create dozens or hundreds of indexes against a table in order to satisfy any possible query. However, you need to remember how an index is constructed. The values from the column on which the index is created are used to build the index. The values within ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.