I got a question from a reader of my post How the Query Optimizer Uses Statistics (http://sqlblog.com/blogs/ben_nevarez/archive/2009/09/03/how-the-query-optimizer-uses-statistics.aspx) and I thought that it would be a good idea to post my answer here. Basically the request was to expand the previous example for a predicate with two columns.
First, a reminder that the histogram only shows the values of the first column of the statistics object. So, how the Query Optimizer does this?
One way to...
No comments yet, be the first one to post comment.