[dba-SQLServer] Adding indexes on fields

John W. Colby jwcolby at colbyconsulting.com
Fri Jan 21 23:31:45 CST 2005


Does anyone know whether it is faster to add many indexes to a table all at
once or each index one at a time?

I have tables where I need to index every field.  I am looking at writing
TSQL code to add indexes and just need to know if I can do all the fields
simultaneously, and if so is it slower or faster than doing so one at a
time.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/





More information about the dba-SQLServer mailing list