January 6, 2017 at 10:46 am
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
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
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