Oracle explain plan

-- Without execution
EXPLAIN PLAN FOR select ...;
SELECT * FROM TABLE(dbms_xplan.display);
-- With execution
SELECT /*+ gather_plan_statistics */  ...;
SELECT * FROM TABLE(dbms_xplan.display_cursor(NULL,NULL,'ALLSTATS LAST'));

Similar codes

0 vote194 views1 answer
How to close external sql connection in laravel
SQL
2 votes181 views1 answer
Postgresql add entry to table
SQL
0 vote183 views1 answer
Sql server pivot rows to columns
SQL
0 vote177 views1 answer
Mysql database is not starting in xampp
SQL
0 vote194 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote212 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote187 views1 answer
Postgresql if else endif
SQL
1 vote195 views2 answers
Test sqlsrv connection
SQL
3 votes146 views2 answers
Mysql sum with condition
SQL
0 vote211 views1 answer
Databricks install odbc driver connect to sql server
SQL