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-