>Mark, thanks for the response. I was hoping you would be around today.
>Well, I probably have both problems as you have stated. I know how VFP uses indexing for optimization, but how does VFP use Oracle indexes in Remote Views? Is it similar to how Rushmore works or not? I realize the Oracle Indexes are used if I use SPT to either pass a SQL statement or run a stored procedure, but I can't seem to find any references to how the indexes are used in the retrieval of Oracle data for Remote Views.

VFP does not use the indexes in Oracle. Oracle does. VFP just passes the SQL to Oracle. Oracle then parses the SQL, optimizes it then uses its own logic to decide which indexes to use. If the retrieval is synchronous, VFP just remains in a wait state until Oracle returns the cursor with the matching rows. If the retrieval is asynchronous, VFP continues code execution beginning with the next line of code after the SQL query is issued.

The same basic rules apply in Oracle when creating indexes. Create an index on columns you expect to use in the where clause. You also usually only need to index large tables. Mostly static lookup tables that have few rows usually do not need indexes. Columns created with a PRIMARY KEY or UNIQUE constraint already have an index.