Try
SELECT Datei FROM ("DBCNAME!" + lcTabelle) ;
WHERE UPPER(Datei) = UPPER(lcPfad) ;
INTO CURSOR TMP_DOKNAME
>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
Gregory