第十章 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博客 ” ，链接：https://blog.itpub.net/11168/viewspace-1035534/ ，如需转载，请注明出处，否则将追究法律责任。
