Here is some code :
SELECT appur
SET FILTER TO ident = the_ident
GO TOP
DO WHILE !EOF()
...do stuff...
SELECT appur
SKIP
ENDDO
I have an index on appur.ident
Would it be faster to do a seek and do the work around it ? And why if the filter is optimized by rushome ?
Thanks
Eric