>>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.
>
>Index stateweek is state+extryear+extrweek ?
>
>- Keith

Yes. BTW, it doesn't show usage of the other index DsID too. May be this Show Plan just doesn't always work correctly...