《Oracle 11g数据库编程入门与实战》习题答案 第十章

SQL> EXPLAIN PLAN

INTO plan_table

FOR

SELECT e.ename, e.sal, e.deptno, s.grade

FROM emp e, salgrade s

WHERE e.sal between s.losal AND s.hisal

AND e.deptno = 10;

SQL> col id for 99

SQL> col parent_id for 99

SQL> col operation for a16

SQL> col options for a15

SQL> col object_name for a8

SQL> col object_type for a14

SQL> col position for 99

SQL> SELECT id, parent_id, operation, options,

object_name, object_type, position

FROM plan_table;

SQL> SELECT sql_handle, plan_name, origin, enabled, accepted, autopurge

FROM dba_sql_plan_baselines WHERE sql_text like

'SELECT ename, sal, deptno FROM emp WHERE UPPER(job) = ''CLERK''';