Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Select ... Except Query Optimization Strategies (Suggestions Requested) Expand / Collapse
Author
Message
Posted Thursday, May 20, 2010 8:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 21, 2010 5:57 AM
Points: 1, Visits: 9
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.
Post #925645
Posted Thursday, May 20, 2010 11:12 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:03 PM
Points: 42,485, Visits: 35,554
Probably. Can't say much more without more info. Do you have the query? If so, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #925673
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse