Deepak Mahto shares a tool with us:
Tuning SQL is an integral part of most developer’s or DBA’s primary responsibilities. Understanding and dissecting problematic execution plans are critical steps in the overall tuning process.
One key ingredient of SQL performance tuning, along with the runtime plan, is object statistics. Looking only at the execution plan is often insufficient for making solid recommendations; we need a fair understanding of current object statistics.As the saying goes,
Behind every optimized SQL query lies a deep understanding of the underlying object stats.
Click through to see examples of the StatsViaExplainAnalyze tool and how you can get a copy of it from GitHub.