Wednesday, May 8, 2013

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

Yes, AFAIK filtered statistics is pretty much your only option.


Oracle has more fine-grained control over statistics, but SQL Server is unfortunately lagging behind here.


No comments:

Post a Comment