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