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

13 votes515 views4 answers
Sql joining 3 tables
SQL
0 vote311 views1 answer
Oracle exchange partition
SQL
2 votes276 views1 answer
Oracle sql drop column if exists
SQL
4 votes300 views1 answer
To date oracle with time
SQL
0 vote316 views1 answer
Mysql foreach insert
SQL
3 votes328 views2 answers
Oracle privileges users
SQL
1 vote298 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
2 votes259 views1 answer
Sql float to int
SQL
1 vote326 views1 answer
Where date = max(date) in sql
SQL
5 votes354 views1 answer
Get column name sql server
SQL