Home Forums SQL Server 2005 SQL Server 2005 General Discussion Index creation after of before populate? RE: Index creation after of before populate?
Dung Dinh
SSCrazy
Points: 2513
More actions
September 13, 2010 at 10:00 pm
#1220426
Which approach if we populate large data into a table many times?
Eg: Today I populate 2GB data follow below steps
Create Clustered Index on table
Insert data
Create Non-Clusterd Index(s)
Tomorrow, I will also populate data into the table.
Thanks,