When doing a Bulk Copy to load large amount of
data into a table, I was told that it would be wise to
(I don't have any existing data in that table)
1) Drop all th existing indexes
2) Bulk copy the data into the table
3) Rebuild the indexes
However if one of the indexes is a clustered index,
would the index-rebuilding process take a very long
time (since SQL Server rearrange the phyical data
around the clustered index) ?
My question is :
Should I just leave the indexes as they are when doing bulk-copy?