In addition to what you've been told already, SET DELETED OFF while you build and test your queries. Especially if the deleted records are not significant. That way you can determine if your query is optimized by focusing on the significant parts.

>Thanks Jim that is indeed true.
>
>Simon
>
>>My guess is that you are operating with DELETED ON and do not have a TAG on DELETED().
>>
>>The usual warning applies - "partial" may be better in THIS case.
>>
>>
>>>Hi
>>>
>>>I have a table indexed on PID+DToS(Date) and when I issue the following query it reports that it is only partially optimized.
>>>
>>>Select * From myTable Where PID+DToS(Date)="!!!!!#"
>>>
>>>I expected it to report that is was fully optimized. Can someone explain why it is only partially optimized?
>>>
>>>It also reports partial optimization when I add the date as follows:
>>>
>>>Select * From myTable Where PID+DToS(Date)="!!!!!#20021225"
>>>
>>>Thanks
>>>Simon