1
kudos
spam Kudos Remove

How the Query Optimizer Uses Statistics – Part II

published 971 days, 7 hours, 39 minutes ago posted by sasa 981 days, 6 hours, 12 minutes ago
Friday, September 25, 2009 1:46:41 PM GMT Tuesday, September 15, 2009 3:13:45 PM GMT

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...

category: Query | clicked: 1 | | source: sqlblog.com | show counter code
tags: Query Optimizer, statistics

No comments yet, be the first one to post comment.

To post your comment please login or signup