About This Blog

A copy of my content originally hosted on SQLBlog.com
Showing posts with label Statistics. Show all posts
Showing posts with label Statistics. Show all posts

Wednesday, 21 September 2011

Finding the Statistics Used to Compile an Execution Plan

Finding the Statistics Used to Compile an Execution Plan

In this post, I show you how to determine the statistics objects used by the query optimizer in producing an execution plan.

Note: This technique only applies to queries compiled using the original (70) cardinality estimation model.