Thank you so much for your quick reply. I guess that I was not quite clear enough. The same query run from VFP, Access and a Java program will yield different results. For example:

SELECT * FROM customer WHERE state = 'OH'

will use the index in java and Access but a full table scan in FoxPro. In the VFP and Access cases, we are connecting to the database using ODBC and the same DSN.


>Hi Toni,
>
>You need the hints
>
>MartinaJ
>
>>Does anyone know what FoxPro is doing with the connection that might induce Oracle to do a table scan rather than use the index? FWIW, we know that this is not a parameter issue because it occurs on JOIN statements as well.
>>
>>Toni-