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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement