Hi Sergey

I understand now. I was trying to add the 'AND NOT DELETED()' to my individual index as opposed to adding an extra index.

Geoff
>Hi Geoff,
>
>As others pointed out, VFP imlicitly addes condition 'AND NOT DELETED()' to your select when SET DELETE is ON. If there's no index on DELETED() than SYS(3054) would report partial optimization. In cases when you're not sure what the reason for partial optimization, you can temporary SET DELETE OFF and run query again to see if no index on DELETED() is responsible or something else.
>
>>Hi
>>
>>I have an index on the 'flatnum' in my customer table.
>>
>>when I
>>
>>

CLEAR
>>LOCAL cmemvar
>>SELECT cust
>>INDEX ON flatnum TAG flatnum
>>=SYS(3054,1,"cmemvar")
>>?DATETIME()
>>SELECT * FROM cust WHERE flatnum="12"
>>? cmemvar
>>?DATETIME()
>>

>>
>>I am told
>>
>>

>>Using index tag Flatnum to rushmore optimize table cust
>>Rushmore optimization level for table cust: partial
>>

>>
>>why is this not full optimization???
>>
>>Regards
>>Geoff Scott