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 vote272 views1 answer
Postgresql select fast check no rows
SQL
0 vote273 views1 answer
Running query in redshift
SQL
0 vote261 views1 answer
How to connect to mysql in ef 6
SQL
0 vote286 views1 answer
Get the next column of a table in mysql
SQL
1 vote308 views2 answers
Install sql server management studio ubuntu
SQL
0 vote281 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote268 views1 answer
Access mysql database docker container shell
SQL
0 vote273 views1 answer
Sql server datetime to string
SQL
0 vote254 views1 answer
Oracle right characters
SQL
5 votes255 views6 answers
Sql add days to date
SQL