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 vote302 views1 answer
Store case result sql
SQL
0 vote175 views1 answer
Mysql last 6 months
SQL
0 vote182 views1 answer
Running query in redshift
SQL
2 votes255 views2 answers
Mysql date range
SQL
0 vote193 views1 answer
Openquery insert into linked server
SQL
0 vote207 views1 answer
Mysql update set sum
SQL
8 votes193 views5 answers
Alter table add column with default value
SQL
15 votes250 views5 answers
Show tables in oracle
SQL
0 vote207 views1 answer
How to create a new shema using query languaage
SQL
0 vote249 views2 answers
Dbms interview questions
SQL