David,

One thing you need to consdier is the difference between local data systems and client/server systems. Basically, you don't ever want to get all 3,000,000 records. You want to give the user an interface that allows them to specify what they need and then get only the records that meet the user's request.

Yes, you can index a view but only in record oriented buffering not in table buffering.

So, if your view is named MyView and it gets opened in table buffering you can;

SELECT MyView
LOCAL lnOldBufferMode
lnOldBufferMode = CursorGetProp("BUFFERING","MyView")
CursorSetProp("BUFFERING",5,"MyView")
INDEX ON ...

CursorSetProp("BUFFERING",lnOldBufferMode,"MyView")