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

1 vote338 views3 answers
Postgresql connect to database
SQL
0 vote418 views3 answers
Constraint sql
SQL
0 vote391 views1 answer
How to install sql in anaconda
SQL
1 vote308 views1 answer
Insert into sql
SQL
0 vote367 views1 answer
Sqlalchemy get schema from database
SQL
1 vote409 views2 answers
Install sql server management studio ubuntu
SQL
0 vote369 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote347 views1 answer
Soql last week
SQL
1 vote324 views1 answer
Select not matching data from two tables
SQL
12 votes358 views2 answers
Update column data type postgres
SQL