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

5 votes117 views1 answer
Sqlite alter table add column
SQL
0 vote123 views1 answer
How to declare variable date in mysql
SQL
0 vote137 views1 answer
How to get one year old query from plan cache
SQL
0 vote121 views1 answer
Mysql update sum same table
SQL
-1 vote143 views1 answer
How to Activate the database
SQL
0 vote132 views1 answer
Postgresql array to rows
SQL
0 vote142 views1 answer
For row in sql database python loop
SQL
0 vote124 views2 answers
Mysql update two tables at once
SQL
0 vote183 views1 answer
Show mysql account privilleges
SQL
0 vote134 views1 answer
Postgres get running query
SQL