Tool for comparison of SQL Server query plans?

sql sql-server sql-execution-plan
davek picture davek · Nov 6, 2009 · Viewed 8.7k times · Source

Does anyone know of a tool that can be used to compare (relatively complex) query plans? I'm not looking for a guide to query plans, but just a tool that enables me to quickly see e.g. the different index use.

EDIT: just to make it clear, I'm not looking for information about the plan, but a tool that can quickly point out the differences between two plans (I know, I could do that myself, but the size of the plan(s) make that difficult).

Answer

devstuff picture devstuff · Nov 6, 2009

I'm not aware of a ready-made tool for this, just if you use SET SHOWPLAN_XML ON to get the plans in XML format you can pretty-format them in Visual Studio, and then compare with your favourite text comparison tool.

And you can also right click on the plan in SSMS and choose Save Execution Plan as... to save to a file.

Related questions

How do I obtain a Query Execution Plan in SQL Server?

In Microsoft SQL Server how can I get a query execution plan for a query / stored procedure?

Read More
Measuring Query Performance : "Execution Plan Query Cost" vs "Time Taken"

I'm trying to determine the relative performance of two different queries and have two ways of measuring this available to me: 1. Run both and time each query 2. Run both and get "Query Cost" from the actual execution plan Here is …

Read More
SQL Server Plans : difference between Index Scan / Index Seek

In a SQL Server Execution plan what is the difference between an Index Scan and an Index Seek I'm on SQL Server 2005.

Read More