HI,

Thanks .

Still i have few concern on your clarification .

1) Your assumption unique no column does not have clustered index . The unique column is common column between both (Working...

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...

Over the period the no of rows can increase more than 500000 , whether LEFT outer join will increase the performance or any other option are available?

Is it Partition of...