Features

Explain Plan

SUPPORTED FOR: DB2 LUW | H2 | JavaDB/Derby | Mimer SQL | MySQL | Netezza | NuoDB | Oracle | PostgreSQL | Amazon Redshift | SQLite | Microsoft SQL Server | Vertica

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.

  • Feature

    DbVisualizer Pro

    DbVisualizer Free

  • Browse plan data in graph format

    SUPPORTED FOR: DB2 LUW | Mimer SQL | MySQL | Oracle | PostgreSQL | Microsoft SQL Server

  • Browse plan data in tree format

    SUPPORTED FOR: DB2 LUW | Mimer SQL | MySQL | Oracle | PostgreSQL | Microsoft SQL Server

  • Browse plan data in text format

    SUPPORTED FOR: H2 | JavaDB/Derby | MySQL | Netezza | NuoDB | Oracle | PostgreSQL | Amazon Redshift | SQLite | Vertica

  • Coloring based on node cost (tree and graph format)

    SUPPORTED FOR: DB2 LUW | Mimer SQL | MySQL | Oracle | PostgreSQL | Microsoft SQL Server

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings.

Close