Топ-100
 

EXPLAIN PLAN

Описания команд доступны в программе CerebroSQL

RDBMS Type: Oracle
Topic

EXPLAIN PLAN
[ SET STATEMENT_ID = string ]
[ INTO [ schema. ] table [ @ dblink ] ]
FOR statement ;

Example

EXPLAIN PLAN
SET STATEMENT_ID = 'Raise in Tokyo'
INTO plan_table
FOR UPDATE employees
SET salary = salary * 1.10
WHERE department_id =
(SELECT department_id FROM departments
WHERE location_id = 1700);