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 vote168 views1 answer
Why we have to set the password for my sql server
SQL
2 votes175 views1 answer
Oracle list grants on procedure
SQL
2 votes192 views1 answer
Oracle kill session by sql_id
SQL
0 vote168 views1 answer
Check duplicate values plsql
SQL
0 vote283 views1 answer
Alter table name including schema
SQL
0 vote161 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote186 views1 answer
Get null value in sql
SQL
0 vote227 views1 answer
Tsql find procedure with name
SQL
0 vote253 views2 answers
Disadvantages of stored procedures sql
SQL
3 votes182 views3 answers
Create table in microsoft sql server
SQL