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 vote277 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote288 views1 answer
Sql server roles and users
SQL
1 vote301 views1 answer
Delete from inner join sql
SQL
1 vote307 views5 answers
What is in operator in sql
SQL
0 vote290 views1 answer
Search column name sql
SQL
27 votes296 views3 answers
Mysql show tables in database
SQL
2 votes327 views1 answer
Pdo mysql insert
SQL
14 votes323 views4 answers
Sql compiler
SQL
0 vote297 views1 answer
Mssql + bit + in python orm
SQL
0 vote299 views1 answer
How to delete duplicate rows in oracle
SQL