Optimize sql query

-- ORACLE: get explain plan for a query
-- 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 vote279 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
2 votes299 views2 answers
Install postgresql
SQL
0 vote302 views1 answer
Oracle drop type
SQL
0 vote285 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote274 views2 answers
What is 1=2 in sql
SQL
5 votes291 views1 answer
JBDC
SQL
6 votes308 views2 answers
Mysql 1 day ago
SQL
1 vote298 views1 answer
Raise application error in oracle
SQL
12 votes327 views6 answers
Change mysql root password
SQL
0 vote289 views1 answer
Mysql beautifier terminla
SQL