T.Ashish (5/17/2013)
If I use query 2/3, then optimizer must be converting it in Inner Join before execution. If I'm right then is there any way I can find out the diferrence between Query I wrote and Query sql executed!!
No, it's not converting it to an inner join, it's already an inner join, just a different way of writing it. Since the queries are logically identical (and the parser and optimiser know that), they are parsed into the same internal format and optimised to the same execution plan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability