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/