Hi,

The record is not 500000 only it can grow like up to 10000000 etc..

Please suggest the best practice to avoid performance issue for the below which one I can prefer.

1) Partitioning based on the Duration (Year or month etc..)

2) Is that instead of Left outer join can I use Inner join for comparison? I feel inner join is the best practice isn't it?

3) Merge statement will it be useful for Comparison and update the record.

I appreciate if you suggest the best possible method

Regards

Anand j