I'll try your suggestion in the other message to see what indexes exist in Oracle, but I think the key field in my WHERE clause has an index.

Also, using the same ODBC datasource in Access runs the query much faster, so I think I have something wrong with my connection in VFP.

Thanks,


>
>Also, I doubt that the drivers are the source of your speed problems. ODBC drivers basically just translate the SQL to the proper syntax needed by the backend DB. From that point, the DB engine takes over running the query. Once the results set has been determined, returning the data over the connection is a result of available bandwidth, number of records, record size, etc. The drivers have very little affect on speed.