Feature TourFeature Tour

Explain Plan

Previous Next

Explain Plan is a way to analyze how a query will be processed by the database, for instance whether an index can be used or if a full table scan is required. The Explain Plan feature supports the following databases: DB2 LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, Netezza, NuoDB, Oracle, PostgreSQL 9+, Redshift, SQLite, SQL Server, and Vertica.

 

                  
This screenshot shows the plan data in a multi-column tree list.
This output format is supported for:
DB2 LUW,
Mimer SQL,
MySQL,
Oracle,
PostgreSQL 9+, and
SQL Server.
Explain Plan as a Tree List

                  
This screenshot shows the plan data in a graph.
This output format is supported for:
DB2 LUW,
Mimer SQL,
MySQL,
Oracle,
PostgreSQL 9+, and
SQL Server.
Explain Plan as a Graph
Feature DbVisualizer
Pro
DbVisualizer
Free
» Browse plan data in graph format
» Browse plan data in tree format
» Browse plan data in text format
» Coloring based on node cost (tree and graph format)