What is Composite Indexes in SQL Server
Posted on February 10th , 2012 by Admin
|
|
A composite index is an index on two or more columns. Both clustered and nonclustered indexes can be composite indexes. Composite indexes are especially useful in two different circumstances. First, you can use a composite index to cover a query. Secondly we can use a composite index to help match the search criteria of specific queries. We will go onto more detail and give examples of these two areas in the following sections. |
|
|
