裏ブログ

家族には内緒のブログ

Oracle EXPLAIN PLANの登録方法

2006-01-15 02:11:06 | DB
EXPLAIN PLAN
set statement_id = 'AAA'
into educ07.plan_table
for select ename
from emp
where ename like 'S%'

EXPLAIN PLAN
set statement_id = 'AAA'
into educ07.plan_table
for select *
from NATION N,BORDER B
where N.CODE = B.desc NATION_CODE


select sysdate from dual


DELETE FROM educ07.PLAN_TABLE
WHERE STATEMENT_ID = 'AAA'