Home Forums SQL Server 2005 SQL Server 2005 General Discussion Index creation after of before populate? RE: Index creation after of before populate?
ricardo_chicas
SSCertifiable
Points: 5024
More actions
September 13, 2010 at 9:31 am
#1220138
Actually my concern is that we have several dbs and ost of users, so I really need to be careful with the use of temp db, I like the approach of
Create table
create clustered index
Inserts
nonclustered