Browse by Tags

• Query Optimizer
• Trace Flags

• How to Find the Statistics Used to Compile an Execution Plan

  In this post, I show you how to determine exactly which statistics objects were used by the query optimizer to produce an execution plan. Trace Flags We will need three undocumented trace flags.  The first one ( 3604 ) is well-known – it redirects Read More... Posted Wednesday, September 21, 2011 5:22 AM by Paul White | 19 Comments Filed under: Query Optimizer, Query Plans, Undocumented, Trace Flags, Statistics