Hi Paul

I am trying to learn the execution plan and aims to become a DBA.

In the above thread i did tried to understand the two execution plans and did get some success but failed to understand how to know which 'compute scalar' computes what expression.

and why the sorting operator has different sequence in both the plans.

Grateful if you could throw some light on the above issues.

Thanks

Deepak !