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.