Very well put Patrice...

>Hi,
>
>I must had that VFP ODBC IS FAST when you know how to use it: do not use functions in the indexes of your tables... A simple UPPER(field) slows down the query a lot: from instantaneous to 5 seconds for a 35k records table for a select of a record where the only WHERE clause was upper(field_name) = 'SOMETHING'. The field name was a 10 caracters fields and the primary key of the table.
>
>So to optimize the queries, no upper (nor DTOS, etc.) in the indexes that the ODBC driver will use to optimize the query.
>
>Patrice