>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

Just to refresh my memory - is "optimisation" with an "s" an acceptable spelling in UK?

Thanks a lot in advance.

As for your question (if it was not already answered - are you running with SET DELETED ON ?)