Sql文本:
SELECT COUNT(1)
FROM TBLREPAIREPOSITIONTOTAL T
WHERE T.BELONGDATE = :B2 AND T.ORGID = :B1 AND ROWNUM = 1
执行次数十几万,每次0.46秒
当前执行计划全表扫描,cost为9000多
查看该package中的逻辑
仅用于判断是否大于0,对于具体数字无要求
建议修改为如下格式,注意写法,内层先取rownum=1,外层再count:
SELECT COUNT(1)
FROM (SELECT 1
FROM tblrepairepositiontotal t
WHERE t.belongdate = :b2
AND t.orgid = :b1
AND rownum = 1)
执行计划的cost为5,检索索引