---------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
---------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 265 (100)| | | |
| 1 | PARTITION LIST SINGLE| | 1 | 756 | 265 (1)| 00:00:04 | KEY | KEY |
|* 2 | TABLE ACCESS FULL | CR_BKG_INTMD_SHMT_PARTITION | 1 | 756 | 265 (1)| 00:00:04 | KEY | KEY |
---------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1
2 - SEL$1 / BKGSHMTRESULT@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.3')
OPT_PARAM('_complex_view_merging' 'false')
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "BKGSHMTRESULT"@"SEL$1")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :V_BKG_CFM_ID (NUMBER): 592533
2 - :V_COMP_ID (VARCHAR2(30), CSID=873): 'BANDHK270600815'
可以看到，两个变量的值分别为V_BKG_CFM_ID : 592533、V_COMP_ID : 'BANDHK270600815'。使用这2个值，再重新解析查询计划，果然是全表扫描：
SQL> explain plan for
2 SELECT *
3 FROM CR_BKG_INTMD_SHMT_PARTITION BKGSHMTRESULT
4 WHERE BKGSHMTRESULT.BKG_CFM_ID = 592533
5 AND BKGSHMTRESULT.COMP_ID = 'BANDHK270600815';
Explained.
SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY());
PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------------------------------------------------
Plan hash value: 554208192
---------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
---------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 756 | 265 (1)| 00:00:04 | | |
| 1 | PARTITION LIST SINGLE| | 1 | 756 | 265 (1)| 00:00:04 | KEY | KEY |
|* 2 | TABLE ACCESS FULL | CR_BKG_INTMD_SHMT_PARTITION | 1 | 756 | 265 (1)| 00:00:04 | 14 | 14 |
责任编辑：小草
您现在的位置： 