Hi Toni,
You need
the hintsMartinaJ
>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-