今天在数据库中查找SQL执行计划时发现了一条额外的filter条件。

一时找不出是哪里设置导致的。查找了DBA_POLICIES视图也没找到该表的Policy

贴出Predicate Information如下：

Plan hash value: 1802187973
 
------------------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name                         | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                              |     1 |    95 |     4   (0)| 00:00:01 |
|*  1 |  TABLE ACCESS BY INDEX ROWID| INVENTORY_PART_IN_STOCK_TAB  |     1 |    95 |     4   (0)| 00:00:01 |
|*  2 |   INDEX RANGE SCAN          | INVENTORY_PART_IN_STOCK_PX01 |     3 |       |     3   (0)| 00:00:01 |
------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   1 - filter("PART_NO"=:B8 AND "LOCATION_NO"=:B5 AND "CONTRACT"=:B7 AND "ENG_CHG_LEVEL"=:B2 AND
              SUBSTR("INVENTORY_PART_IN_STOCK_TAB"."PART_NO",1,17)=SUBSTR(:B8,1,17) AND "CONFIGURATION_ID"=:B6
              AND "LOT_BATCH_NO"=:B4 AND "SERIAL_NO"=:B3)
   2 - access("WAIV_DEV_REJ_NO"=:B1)

SUBSTR("INVENTORY_PART_IN_STOCK_TAB"."PART_NO",1,17)=SUBSTR(:B8,1,17) 为额外增加的Predicate 。不知道什么时候才能发现你在哪里。