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