I have a DTS package that bulk copies data from text files
into a staging table and then adds an index to speed the
parsing out of rows into another destination table. Then
indexes are adding to the destination table to speed some
data quality queries that run against it. At the moment
the package truncates the tables and drops the indexes
before moving the data.
Would it be more efficient to drop the tables and then re-
create them as opposed to truncating and then waiting on
the several drop index statements?