Visual Explain Overview

You can use Visual Explain to create a query graph that graphically displays the execution of your SQL statements. You can use this tool to see information about both static and dynamic SQL statements. Visual Explain supports the following types of SQL statements:

You can also use this tool to better understand where the highest costs of your queries are taking place. You can improve query performance by:

You can also use Visual Explain to:

For more information, see Database Performance and Query Optimization in the Information Center Link to Information center.