Oracle show execution 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 vote172 views1 answer
Sql server information_schema temp tables
SQL
0 vote143 views1 answer
Check if string is a number sql
SQL
13 votes140 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote136 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote161 views1 answer
Full outer join in mariadb mysql
SQL
0 vote151 views1 answer
Como hacer una consulta en sql
SQL
2 votes221 views1 answer
Oracle run_duration to number
SQL
11 votes139 views2 answers
Oracle all source
SQL
0 vote140 views1 answer
Sql developer search all packages for text
SQL
13 votes167 views2 answers
Oracle inner join
SQL