Hi everybody,
I've created a local view in View Designer and modified it in EView. I modified SQL to be
SELECT rcode, town, record_fm, record_to, landct_fm, landct_to, ;
calmnth, mdflag, nodata, notes, ddflag, dsid, state, extryear, extrweek, ;
ccode FROM support!filingdate ;
WHERE BETWEEN(dsID , ?lnIdLow, ?lnIDHigh) ;
AND between(state+extryear+extrweek, ?lcStWkLow, ?lcStWkHIgh) ;
ORDER BY extryear DESC, extrweek DESC, rcode, town
On the SQL showplan I see
Using index tag Deleted to rushmore optimize table filingdate
Rushmore optimization level for table filingdate: partial
I have both indexes on DsID and StateWeek in FilingDate table. Do you know, what's the problem?
Thanks in advance.
If it's not broken, fix it until it is.
My Blog