How to Fast Fetch Oracle Data in a grid ASP.NET VB

HI,

I have a problem can anyone suggest. I have made an online application for my company by which users can search thr Claims records. I have made a view in oracle database and Using OLDB Connection in my ASP.NET application. The problem is that when the user enter Range of Dates the system will take 2 much time for finding even a single claim record. We have more than 1 million records in a table. Can any one suggest me what i will do? Its very urgent please

re: How to Fast Fetch Oracle Data in a grid ASP.NET VB

1) optimize your database.. create index on searching columns
2) use OracleClient or ODAC
(surely faster than OLEDB)