Hi TJ

When you execute an SQL command, VFP uses the indexes and tables to Rushmore optimize the query and return a set of data (a cursor or view). Once you have the set of data, if you did things like ...

select (view or cursor)
locate for

or even another SQL command involving the view or cursor, you'd need indexes for Rushmore optimization on the cursor or view. However, you should not have so many records in your cursor or view that you'd need to optimize such queries.

I hope that clarifies this for you.