[dba-SQLServer] Adding indexes on fields

Not sure what you mean by adding indexes one at a time or all at once.  Do 
you mean doing the index creation on same table using one connection or 
multiple connection simultaneously?

>From: "John W. Colby" <jwcolby at colbyconsulting.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] Adding indexes on fields
>Date: Sat, 22 Jan 2005 00:31:45 -0500
>
>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/
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>