I don't think that having deleted records or not matters, but SET DELETED ON does matter (picky, I know) as far as FULL/PARTIAL is concerned.

And as you say, PARTIAL is probably fine in most cases.


>Do you have any deleted records in the table? Is SET DELETED ON? Without a tag on deleted(), you won't be fully optimized. But this is not necessarily bad. You would have to experiment to see if it is faster to have a tag on deleted() for this table.
>
>Hilmar wrote an article on this somewhere...maybe it is in the UT magazine; it would have been several months ago (maybe more than a year).
>
>
>>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