Oracle explain plan

-- 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 vote192 views1 answer
How to add boolean column in postgresql
SQL
1 vote210 views1 answer
Db.Database.SqlQuery
SQL
0 vote187 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote196 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote196 views1 answer
How to remove identity from a column in sql server
SQL
0 vote192 views1 answer
Insert or update cassandra
SQL
0 vote208 views1 answer
How to find database collation in postgres
SQL
44 votes274 views6 answers
Rename command in sql
SQL
0 vote198 views1 answer
SQL authentication error
SQL
1 vote256 views1 answer
Oracle apex version view
SQL