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 vote224 views1 answer
Sql insert query list of dictionaries
SQL
1 vote242 views2 answers
This month mysql where
SQL
0 vote224 views1 answer
Transaction database with php
SQL
12 votes214 views4 answers
Mysql version
SQL
0 vote278 views1 answer
Drop view sql
SQL
2 votes223 views3 answers
Sql server reseed identity column
SQL
0 vote224 views1 answer
How to declare variable date in mysql
SQL
3 votes312 views1 answer
How to get yesterday date in sql
SQL
0 vote216 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote219 views1 answer
Sql query tags
SQL