[dba-SQLServer] Covering Indexes

jwcolby jwcolby at colbyconsulting.com
Wed Nov 28 19:07:03 CST 2007


I need to understand covering indexes.  One of my databases has fields such
as 

PresenceOfChildren_00_02
PresenceOfChildren_03_05
PresenceOfChildren_06_10

Etc.  Thus what I need to know is do I need an individual index on each
field?  I get requests for data using selection criteria on just one, and
also sometimes on more than one of these fields.  If I have an index on all
of these fields together, will that help a query with selection criteria for
a single one of these fields?  On 3 out of 7 of these fields etc?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 




More information about the dba-SQLServer mailing list