Explain Plan

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: Azure SQL Database, Db2 LUW, Derby, Greenplum, H2, MariaDB, Mimer SQL, MySQL, Netezza, NuoDB, Oracle, PostgreSQL 9+, Redshift, SQLite, SQL Server, Vertica, Yellowbrick.