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

0 vote392 views1 answer
Mysl like insert a variable
SQL
0 vote332 views1 answer
Create query in where clasue
SQL
11 votes385 views1 answer
Oracle insert from select
SQL
0 vote320 views1 answer
Why mysql is used?
SQL
6 votes330 views5 answers
Alter table oracle
SQL
5 votes312 views1 answer
Oracle ora-00054 causes
SQL
0 vote338 views1 answer
How to add timestamp column in mysql
SQL
8 votes341 views3 answers
Alter user root mysql
SQL
0 vote315 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
-1 vote299 views1 answer
How to format tables in sqlplus
SQL