对于一个很大的数据库表，索引正常，但查询时不能利用索引怎么办？

hxcqu

建议你删除表的统计分析信息，采用RBO试试看

fenglhua

对,直接使用RBO试试

xiaodong_1567

关注

zoracledba

"我的脚本如下:
select * from tDstDpsData T
where Exists(select 1 from tStkPc where OrgCode=T.OrgCode and PluID=T.PluID and JsCode='2')"

-- Not sure how many rows in table tStkPc, and how many rows satisfy the where clause condition;
-- Make sure all the three columns: OrgCode, PluID and JsCode got indexes;
-- Make sure you did collect the stattistics of the tablle and the indexed column of that table;

-- After above step, please generate the sql explain again, and show us the plan.

Thanks!
zOracleDBA