D
David
Guest

And moreover, if I use index vdmod_idx1 in my query to then only it picks vdmod_idx1
Code:
for last vdhist no-lock
where vdhist.vddomain = dom
and vdclassification = 1
and vdhist.vdlist = prlt
and vdhist.vdprod_ln = prodLn
and vdhist.vdcurr = curr
and vdhist.vdpart = part
and vdhist.vdum = tt_um
and vdhist.vdstart = date(tt_start)
and vdmod_date > 01/01/2021
and vdmod_time > 45556:
end.
Index used
Code:
pu vdlist 10 + vddomain
+ vdclassification
+ vdlist
+ vdprod_ln
+ vdcurr
+ vdpart
+ vdum
+ vdstart
+ vdcrt_date
+ vdlocal_rsn
vdmod_idx1 10 + vddomain
+ vdclassification
+ vdlist
+ vdprod_ln
+ vdcurr
+ vdpart
+ vdum
+ vdstart
+ vdmod_date
+ vdmod_time
Continue reading...