your sql has only one predicate:Where retord.SYNCPOSFLAG=0and plan has a decfloat apply to it. AND (DECFLOAT(Q2.SYNCPOSFLAG, '............') = 0)seem syncposflag is a char/varcharwrite your predicate as syncposflag = '0'change i...
显示全部your sql has only one predicate:Where retord.SYNCPOSFLAG=0
and plan has a decfloat apply to it.
AND (DECFLOAT(Q2.SYNCPOSFLAG, '............') = 0)
seem syncposflag is a char/varchar
write your predicate as syncposflag = '0'
change index design:
CREATE UNIQUE INDEX "OMSADM "."I_RETORDER_11" ON "OMSADM "."SO_RET_ORDER"
("RETORD_ITEM_ID" DESC)
INCLUDE ("SYNCPOSFLAG" )
and add 'optimize for 1 row'
收起