• Jeff Moden - Monday, May 29, 2017 7:44 AM

    That's a great idea, Eirikur.  Simple and will have a major impact by probably reducing the amount of work that actually needs to be done to hundreds instead of tens of thousand.  This just keeps getting better and better.   I'll let you know how it turns out performance wise.

    I normally do this with the addition of max exec time and such metrics in addition to the plan hash, if query is going worse then that should trigger an action.
    😎