/*************************** ** START CUSTOM HIGHLIGHTING ****************************/ // tsql language not available by CDN /************************ * END CUSTOM HIGHLIGHTING *************************/ September 2011

About This Blog

Including content from SQLperformance.com & SQLblog.com

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.