Thursday, January 8, 2009

Tip #24 – Resizing the SQL Execution Plan Display

The SQL Execution Plan is a useful tool which can help optimize your SQL statements. It provides both a resultset containing details about each step of the plan as well as a graphical representation of the plan. With complex SQL statements the plan can involve many steps which makes the graphical representation large.

ARC_SQLPlanZoomLevel To make the graphical plan more manageable ARC has three zoom levels available. Simply right click on the Execution Plan tab and choose the zoom level you want. The following screenshots show the various zoom levels ( click for full size images ).

 Execution Plan 50%  Execution Plan 100%  Execution Plan 150%

No comments: