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