17,377
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
lichengqm 2003-10-20
- 打赏
- 举报
请问explain plan 解释结果是不是在plan_table里，如果是，我解释一个sql语句后表里什么也没有？？？
bzszp 2003-10-20
- 打赏
- 举报
Run the SQL script UTLXPLAN.SQL to create a sample output table called PLAN_TABLE in your schema.
sample:
EXPLAIN PLAN FOR
SELECT * FROM T
WHERE
C1 = 2 AND C2 <> 6
OR
C3 BETWEEN 10 AND 20;
sample:
EXPLAIN PLAN FOR
SELECT * FROM T
WHERE
C1 = 2 AND C2 <> 6
OR
C3 BETWEEN 10 AND 20;
