Hi,

I have a table 'person' with 11000 records and a small temporary dbf 'localTest' with 9 records.

The query below takes 10(!) seconds to perform and the resultset is 65 records. The SET DELETED setting does not change this time, nor if I have an index on UPPER(id) in 'localTest'. There is an index on UPPER(person.company_id).

SELECT person.firstname ;
FROM person ;
WHERE UPPER(person.company_id) IN (SELECT UPPER(id) FROM localTest)

Does anyone know how this query can be optimized so that it uses Rushmore, or is this not possible??


Klas Nygren