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

第十章 SQL语句优化

1．略

2．略

3．略

4．不会应用该索引

5．略

6．略

7．

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;

8．略

9．

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

10．略

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11168/viewspace-1035534/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11168/viewspace-1035534/