>I have a VFP6 connection to a Oracle 7.3 database that works but does not seem to be using the Oracle indexes for queries. Is there anything that can be modified in the ODBC data source or the VFP remote view to fix this?
>
>If not, are there any native drivers for Oracle that work with VFP?
>

My first suggestion is to run the following in Oracle to see what indexes there are on your tables:

select ic.index_name, ic.column_name, ic.column_position, ix.uniqueness 
   from user_indexes ix, user_ind_columns ic 
   where ic.index_name = ix.index_name 
   and ic.table_name = 'My_Table_Name_Here';

You could paste this code into a .SQL file, and use SQL Plus to run the script [e.g., type: @myscript at the SQL Plus prompt]. You could also create a parameterized view with the code and pass the table name as the parameter.

You can get ODBC drivers from Oracle, InterSolv and MS. I have seen others mentioned here but can not remember them all. I use MS ODBC drivers and have had really good performance from them.