Post reply

Query regression by index or statistics?

  • January 6, 2017 at 10:46 am

    #1921174

    Here is article with exactly the same case study

    https://blogs.msdn.microsoft.com/psssql/2010/09/28/case-of-using-filtered-statistics/

    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

  • January 16, 2017 at 4:14 am

    #1922932

    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.

    Tom

  • January 17, 2017 at 6:53 am

    #1923157

    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