>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.

Do you have index on state+extryear+extrweek?