top of page
© 2025 by The Clinic. Powered and secured by Wix
Query Editor: Query Execution Plan
Menu
oracle
SQL query plan for Oracle DBMS
EXPLAIN PLAN FOR <QUERY TEXT>
select * from TABLE(DBMS_XPLAN.display(NULL,NULL,'all'))
PostgreSQL
SQL query plan for PostgreSQL DBMS
EXPLAIN VERBOSE <QUERY TEXT>
MSSQL
SQL query plan for MS SQL Server DBMS
SET SHOWPLAN_ALL ON
<RUN SQL TEXT>
SET SHOWPLAN_ALL OFF
MySQL
SQL query plan for MySQL DBMS
EXPLAIN <QUERY TEXT>
SQLite
SQL query plan for SQLite databases
EXPLAIN QUERY PLAN <QUERY TEXT>
bottom of page