I have an application which accesses a 70,000 record(140 fields) Oracle table. I use a remote view to access this table.
I set the following view properties:
Max Records: all
Fetch SIze: 50
Fetch as needed: True
Fetch Memo: False

When I try to 'Locate' or 'Go Top' etc, it is very slow. So, I try to create an index on the view. But, creating index on this huge table is very slow(4 mins).

My question is, how can I make the retrieval fast and still don't take much time on creating indexes while opening my application.

Any help is greatly appreciated.

Thanks