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 vote257 views1 answer
Many rows to 1 string mysql
SQL
0 vote301 views1 answer
Array aggre distinct postgres
SQL
0 vote213 views2 answers
Denormalization in sql
SQL
2 votes257 views3 answers
3 days back in sql server
SQL
1 vote256 views1 answer
Mysql connect command
SQL
0 vote254 views1 answer
Mysql delete from where like
SQL
14 votes276 views3 answers
Trim sql
SQL
0 vote262 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote273 views1 answer
Get a list of tables and the primary key
SQL
0 vote288 views1 answer
Oracle winter time change
SQL