Sql

Search

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'));

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql delete multiple conditions
Sql :: turn off safe mode mysql
Sql :: t sql check active deadlock
Sql :: sql server cannot create database diagram
Sql :: python escape string for sql
Sql :: sql select divide column by number
Sql :: use of now() in mysql
Sql :: backup postgres database
Sql :: sql rename column
Sql :: create table with select
Sql :: oracle last day of month
Sql :: make a field auto_increment mysql
Sql :: oracle alter table delete column
Sql :: psql datetime grather than
Sql :: oracle undo usage by session
Sql :: dynamic sql invalid table name
Sql :: create database hive
Sql :: oracle list duplicates
Sql :: mssql find deadlocks
Sql :: sql order by ascending
Sql :: postgres select max value
Sql :: mysql first day of month date
Sql :: date diff sql
Sql :: get value from a table an insert it with other values in another table sql
Sql :: mysql extract month from date
Sql :: connectionstring mysql c#
Sql :: oracle show column of table
Sql :: how to truncate all table in mysql workbench
Sql :: t-sql merge example
Sql :: multiple count in sql

Search

SQL

oracle explain plan

ADD CONTENT