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 in DbVisualizer supports DB2 LUW, Oracle, SQL Server, Mimer SQL and PostgreSQL 9+.

 

                  
The explain plan feature presents detailed information about how a specific
SELECT statement will be processed by the database. The plan data gives a lot
of information and is a great tool for improving select statement performance. This screenshot show the plan data in a multi-column list.
The explain plan feature is supported for Oracle, DB2 for LUW, SQL Server and Mimer SQL.
Explain Plan as a Tree List

                  
The explain plan feature presents detailed information about how a specific
SELECT statement will be processed by the database. The plan data gives a lot
of information and is a great tool for improving select statement performance. This screenshot show the plan data as a tree.
The explain plan feature is supported for Oracle, DB2 for LUW, SQL Server and Mimer SQL.
Explain Plan as a Graph
Feature DbVisualizer
Pro
DbVisualizer
Free
» Browse plan data in graph view
» Browse plan data in tree view
» Coloring based on node cost
» Export/Copy plan data