Dan,Quote:> Depending on you hardware and
> database setup (# of processors, separate index segments, dual-channel
> controllers, multiple controllers), you may be able to improve elapsed time
> by creating the non-clustered indexes in parallel.
Indices on the same table can't be created in parallel on SQL 6.5 due to
system table locks. (It works fine in SQL 7.0 and gives a HUGE improvement)
Neil Pike MVP/MCSE
Protech Computing Ltd