Oracle绑定变量Bind Peeking(二)

2014-11-24 17:34:33 · 作者: · 浏览: 1
Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 136 (100)| |
| 1 | SORT AGGREGATE | | 1 | 4 | | |
|* 2 | INDEX FAST FULL SCAN| ACS_TEST_TAB_RECORD_TYPE_I | 48031 | 187K| 136 (1)| 00:00:02 |
----------------------------------------------------------------------------------------------------


Peeked Binds (identified by position):
--------------------------------------


1 - :V (NUMBER): 2 --绑定变量窥探,绑定变量会影响最初硬解析的执行计划


Predicate Information (identified by operation id):
---------------------------------------------------


2 - filter("RECORD_TYPE"=:V)



已选择49行。