[dba-SQLServer] Multi-field vs field indexes

JWColby jwcolby at colbyconsulting.com
Wed Jan 17 07:59:06 CST 2007


Can someone write (or point to) a description of single field vs multi-field
indexes.  Let's take an example of city/state/zip.  If I created a single
index for all three of these fields, would the index be useful for the
individual fields as well.  If I were to do a join on Zip, would the
multi-field index be used to select the zips for the join or would a single
field zip index be needed in such a case?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 



More information about the dba-SQLServer mailing list