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