Caroline,

When SET DELETE is ON VFP looks for index on DELETED() to optimize query. If you don't have such index VFP will show partial optimization. Addidng index on DELETED() may or may not speed up your query. To verify that missing index on DELETED() is responsible for partial optimization you can temporary SET DELETE OFF and rerun your query.

>Hello all,
>
>Could someone please explain something to me?
>If I have a local view on to a single table that just selects some output fields and filters on an ID value being equal to a variable. If my table is indexed on the ID why does my optimisation come back saying that it is using the index but that it is only partially optimised?

>SELECT *;
> FROM ash!agent;
> WHERE Agent.iid = ?ThisForm.ID
>
>
>Using index tag Id to rushmore optimize table agent
>Rushmore optimization level for table agent: partial

>
>And does this matter?
>
>Many thanks
>