O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required