oracle 5种索引方式,Oracle CBO优化模式中的5种索引访问方法浅析

SQL> set autotrace traceonly explain

SQL> select * from hr.employees where employee_id = 100;

Execution Plan

----------------------------------------------------------

Plan hash value: 1833546154

---------------------------------------------------------------------------------------------

| Id  | Operation                   | Name          | Rows  | Bytes | Cost (%CPU)| Time     |

---------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT            |               |     1 |    69 |     1   (0)| 00:00:01 |

|   1 |  TABLE ACCESS BY INDEX ROWID| EMPLOYEES     |     1 |    69 |     1   (0)| 00:00:01 |

|*  2 |   INDEX UNIQUE SCAN         | EMP_EMP_ID_PK |     1 |       |     0   (0)| 00:00:01 |

---------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

2 - access("EMPLOYEE_ID"=100)

这就是微学网-程序员之家为你提供的"Oracle CBO优化模式中的5种索引访问方法浅析"希望对你有所帮助.本文来自网络，转载请注明出处：http://www.weixuecn.cn/article/6488.html