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.
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 ).
No comments:
Post a Comment