Query regression by index or statistics?

  • Here is article with exactly the same case study


    It does not have deep technical explanation, unfortunately. Respect to author of question.

    MS SQL 2008 MCITP x 3
    MS SQL 2012 MCSE x 2

  • I very much liked this question.  Spent more than an hour thinking about what the optimser must be doing.  Once it clicked it was obvious, but it's a problem I'd never thought about before. 
    I will certainly be careful in future to look and see if I need to have filtered statistics in cases where the flat distribution assumption will cause misestimation that could lead to problem.  I guess the reaon I never thought about it before was that it had never caused performance issues that were as important as other performance issues (many of them not SQL).
    Thanks very much for the question.


  • Nice question, good explanation

    - Damian

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply