GilaMonster (5/19/2013)
If you have different plans then either:* The queries are not logically equivalent
* The different form resulted in the optimiser searching a different area of the plan space and finding a different optimal plan. Since that's dependent on the optimiser's estimates, heuristics and search algorithms this will not be consistent.
As for 'different performance', you ran multiple tests, ignored runs that incurred the overhead of compiling and data caching, analysed the results and came up with a statistically significant change?
My thinking is , i should have all the corresponding joins together then move on to other join with another table?