Multi-column indexes 
Author Message
 Multi-column indexes
Can someone point me to documentation on when, if ever, multi-column
indexes should be used vs. indexes on the individual columns.

Todd



Sun, 17 Jul 2005 17:50:29 GMT
 Multi-column indexes

Look up "Composite Index" in SQL Server books online.


Quote:
> Can someone point me to documentation on when, if ever, multi-column
> indexes should be used vs. indexes on the individual columns.

> Todd



Sun, 17 Jul 2005 17:54:24 GMT
 Multi-column indexes
Search on Microsoft.com using the keywords "SQL Server Performance Tuning".
One or more of the articles that come up will provide information to aid you
in making such determinations.

--

This posting is provided "AS IS" with no warranties, and confers no rights.

Djana O.C. Milton


Quote:
> Can someone point me to documentation on when, if ever, multi-column
> indexes should be used vs. indexes on the individual columns.

> Todd



Sun, 17 Jul 2005 20:18:24 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Multiple indexes or multi-column index?

2. Multi column index versus many indexes (7 vs 2000)

3. using multi column index

4. Seek on a multi-column index

5. ADOCE seek multi-column index

6. Multi-column indexes

7. multicolumn index vs two indexes

8. multicolumn index vs two indexes

9. Multicolumn index - is there a limit?

10. Multicolumn Indexes

11. ADO Seek with multicolumns-index and Sql Server 2000

12. ADO Seek with multicolumns-index


 
Powered by phpBB® Forum Software