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

4 votes166 views1 answer
What are the data types in sql
SQL
0 vote161 views1 answer
Mysql update privileges
SQL
0 vote180 views1 answer
Postgresql interview questions
SQL
0 vote201 views1 answer
Install mysql on bash
SQL
16 votes158 views3 answers
Order by sql query
SQL
0 vote187 views2 answers
Mysql dump database tables only
SQL
-1 vote208 views5 answers
Left join sql
SQL
0 vote167 views2 answers
Sql searching via key word
SQL
0 vote165 views1 answer
Oracle procedure chain step
SQL
0 vote187 views2 answers
How to know the character set of an oracle databes
SQL