Home Forums SQL Server 2005 SQL Server 2005 General Discussion Index creation after of before populate? RE: Index creation after of before populate?
WayneS
SSC Guru
Points: 95409
More actions
September 13, 2010 at 9:14 am
#1220129
If you are inserting a large amount of data, you will probably find it faster to add the index afterwards.
WayneMicrosoft Certified Master: SQL Server 2008Author - SQL Server T-SQL Recipes