>>T1=SECONDS()
>>? "BAD: this uses TFF1 and is optimized"
>>SELECT count(FF) FROM ALIAS() INTO ARRAY AX
>>? SECONDS()-T1
>
>Does it really make use of TFF1? optimizing Count() can be done if rushmore sees, that the count() is equal to reccount(). Due To SET DELETED OFF that is valid, as there is no filter in effect. So I think this time rushmore in fact uses the reccount() stored in the table header to optimize the query, not an index.
>
>Bye, Olaf.
You are correct, but it still BAD because RECCOUNT() is an optimization also it:
CREATE CURSOR cc (ff i)
DIMENSION AX[1000000,1]
APPEND FROM ARRAY AX
INSERT INTO cc VALUES (2)
CLEAR
SET DELETED OFF
T1=SECONDS()
COUNT
? SECONDS()-T1
T1=SECONDS()
CALCULATE CNT()
? SECONDS()-T1
T1=SECONDS()
SELECT count(*) FROM ALIAS() INTO ARRAY AX
? SECONDS()-T1