Poll: SQL Plan Management
May 4, 2012 3 Comments
I’m interested in what SQL Plan Management features people are actively using.
For example on one system I’m working on, we use SQL Plan Baselines selectively, we have a couple of sql profiles as they were originally intended (i.e. as mechanisms for adjusting the optimizer’s estimates) and at least one sql profile created via the SQLT/COE method (i.e. outline-style hints). And, instead of hinting problem statements manually and inadequately, I’m pushing people towards using more and more of all three of these approaches depending on the scenario.
Another system has baselines off completely whilst another has pretty much everything baselined.
It very much depends on the system, who implemented it and what exact version the system was originally implemented on or upgraded to, and what problems they had during the implementation
If you have had any interesting experiences with any of these features then please add a comment.