I am moving bulk data to archive tables.
Some times query returns up to 4.5million records, which takes about 2:15 minutes for a table of 40 columns.
I want too increase the performance for the selection by using a temporary non clustered index and drop that index after select operation.
I am also setting data base logging to bulk logging while performing the bulk operation.
Will that really help, or it is even possible o not.
Any other suggestions are also welcome.
SELECT FROM <TABLE>
or are there joins? It seems very slow regardless of the indexing if it's just simply selecting 4,500 records from one table