Wednesday, May 8, 2013

Can I prevent SQL Server from consolidating histogram steps in statistics?

Hmm, how about creating more filtered statistics exactly on the problematic ranges?


Or, tackling this from the other end, using OPTIMIZE FOR in the query and specifying a good range (or perhaps UNKNOWN)?



Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)