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
Steve Gibson