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