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

14 votes265 views2 answers
Sql cast
SQL
0 vote286 views2 answers
Advantages of stored procedures sql
SQL
0 vote273 views1 answer
Alter table myisam to innodb
SQL
10 votes275 views5 answers
Between keyword in sql
SQL
0 vote264 views1 answer
Get time component of datetime sql
SQL
0 vote267 views2 answers
Plan d'exécution requete oracle autotracer
SQL
17 votes279 views6 answers
Current date in sql
SQL
0 vote456 views1 answer
Multiple row join
SQL
0 vote288 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote261 views1 answer
Type int in mysql maxlenght
SQL