I am writing an SSIS package to compare an existing table to a new copy of the data in the table that will normally have numerous row changes and additions. The previous month's data is stored in a table with the same structure and can be indexed prior to the compare operation. The current month's data can also be indexed prior to the compare. Would it be helpful to index the compared columns prior to running a Select ... Except ... statement?
Can you offer any other optimization strategies?
Thanks for considering this question.