Execution Plan Articles

Page 1 of 1 (4 articles)

9/16/2017 • EN

A guide to using the new 'Compare ShowPlan' feature in SQL Server Management Studio 2017 to analyze and contrast SQL execution plans.

Database Performance Execution Plan Query Optimization SQL Server Ssm

8/12/2014 • EN

Explains why SQL Server's dm_exec_query_plan returns NULL for stored procedures with conditional logic and temp tables, and how to diagnose it.

Dm_exec_query_plan Execution Plan Plan Cache Query Optimization SQL Server

3/25/2010 • EN

How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.

Execution Plan indexing mysql Query Optimization SQL Performance

2/9/2010 • EN

Explains the importance of clearing SQL Server's data and execution plan caches for fair query performance comparisons during tuning.

caching Execution Plan performance Query Tuning SQL Server

Select Language