oracle 不能走索引问题
SQL 语句:
SELECT t.CSTM_NO,t.acc
CM.CUSTMER_MANAGER_ID
FROM MPM_PCUST_MNG_INFO CM,
MPM_PACC_INFO t
WHERE CM.CUSTMER_MANAGER_ID = '330118065'
AND CM.CONFORM_INDPARTY_ID = t.CSTM_NO;
索引 :
MPM_PCUST_MNG_INFO表:
alter table MPM_PCUST_MNG_INFO add constraint PCUST_MNG_INFO primary key (CONFORM_INDPARTY_ID, CUSTMER_MANAGER_ID)
MPM_PACC_INFO 表:
create index PACC_CSTM_NO_IDX on MPM_PACC_INFO (CSTM_NO, ACC_TYPE, OPEN_INST) 。
得到的执行计划如下:
SELECT STATEMENT, GOAL = ALL_ROWS 411842 9 468
HASH JOIN 411842 9 468
INDEX FULL SCAN MPM PCUST_MNG_INFO 1 4 68
PARTITION RANGE ALL 411243 66416252 2324568820
TABLE ACCESS FULL MPM MPM_PACC_INFO 411243 66416252 2324568820
MPM_PCUST_MNG_INFO表数据量100多条,关联CM.CUSTMER_MANAGER_ID = '330118065'条件后只有2条记录,MPM_PACC_INFO表有6600多万记录,而且经过分区的。
还请CSDN各位大侠解答,为什么MPM_PACC_INFO表没有走PACC_CSTM_NO_IDX这个索引,在另外的测试环境上,MPM_PACC_INFO记录只有200多万的时候是能够走索引的。