Geoff,
If you want add index for DELETED() check new BINARY clause in INDEX command. Keep in mind that using this clause will make your table incompatible with previous VFP versions and VFP ODBC driver.
INDEX ON DELETED() TAG deleted BINARY
>
>From my testing it appears that the Deleted() index is needed in order to get full optimization. Setting DELETED ON or OFF does change whether optimization is Full or Partial and probably affects performance.
>
>There appears to be some other slight changes in the way optimization is performed with regard to composite (complex) indicies but I have rectified these by changing the index.
>
>There also appears to be a slight degredation with macro substitution but I suspect that this is more to do with caching than anything else.
>
--sb--