Hello,

I have a perfomance problem with a simple SQL SELECT in VFP 9:

SELECT Datei FROM ("DBCNAME!" + lcTabelle) ;
WHERE Datei = UPPER(lcPfad) ;
INTO CURSOR TMP_DOKNAME

The column DATEI is defined as C(240) and has an index on UPPER(DATEI).

The table has about 900.000 records. The SELECT above needs 3 seconds to finish.

USE DATA\DAKDOC IN 0 ALIAS TEST
SELECT TEST
SET ORDER TO DATEI
SEEK(UPPER(lcPfad))

finishes in 0 seconds. That seems to indicate that Rushmore is kicking in.

Why is Rushmore not used in the SELECT?

TIA
Gerhard