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
What is the difference between now() and current_date()?
SQL
0 vote159 views1 answer
IIF
SQL
0 vote171 views1 answer
How to reset the database value in SQL server
SQL
0 vote174 views1 answer
Postgres set default schema
SQL
0 vote222 views1 answer
Copy from one table to another postgres using matching column
SQL
5 votes166 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote216 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
2 votes183 views1 answer
How to delete columns in sql
SQL
0 vote176 views2 answers
Close external port 3306 with iptables
SQL
24 votes183 views6 answers
Rename a column in sql server
SQL