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 vote330 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
1 vote325 views1 answer
Autocommit mysql
SQL
0 vote322 views1 answer
Access refused mysql xampp server
SQL
0 vote335 views1 answer
Download mysql database to excel in android studio
SQL
1 vote361 views1 answer
Load mysql dumb
SQL
0 vote360 views1 answer
Top frequency in sql server
SQL
10 votes353 views5 answers
Mysql create user
SQL
2 votes394 views2 answers
Mysql compare datetime to another datetime
SQL
10 votes339 views6 answers
Between sql
SQL
2 votes347 views2 answers
How to check data type in sql server
SQL