>Hi,
>
>I have created an connection (ODBC) to an Oracle database, and a view. Why is this view not optimized by Oracle?????
>
>SELECT * FROM PROD WHERE ID=12345
>Gets an 'Executing remote' and '1 record in 300 seconds' message.
>
>An explain plan show that Oracle has an index on ID, but FoxPro is fetching all the records...
>
>Is this Client-Server or what????
>
>What am I missing,
>TIA
>Jean-Pierre

Sorry,

I have rewritten the thing to SqlExec. Now the speed is OK.
Sorry 4 your time!!!!
Jean-Pierre