Hi Rick,
>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.
You dont. The idea with a client-server design is that you ask your users what they want to work on. Use these values as parameters and requery() a parameterized view, thus limiting the number of records.