Arjun Sivadasan (9/8/2010)
I saw Jeff mention that rules should be enabled only on a test server. Does it mean that the improvements, that you make to queries this way, cannot be used in a real-world scenario?
Nope, the optimizer normally produces a very good plan by using all of the rules.
What I am doing in this first part, is showing you what horrible plans can be produced if we prevent the optimizer from using all of its tricks.
The point is to show the process the optimizer goes through when searching for a great query plan.
Part 2 will be published in a few hours. In fact it's already an hour late in my time zone 😀
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi