Oracle Queries running Slow
813610Nov 12 2010 — edited Nov 12 2010Hi All,
We are interfacing with an Oracle Database with our ASP.NET application. Now Oracle database has thousands of rows of data, when we search by using unique identifier it displays data in no time.
But when we search using combination of fields such as Surname, Sex (M/F), Date of Birth (Query designed according to the Oracle's DBA's instructions using certain fields to find data quickly) it takes almost 5-10 minutes to search the data and display any result whether anything found or not.
Is there any solution anyone can suggest? How can we get the data quickly in less than 20/30 seconds. I understand that there might be millions of rows of data but there must be an easy way to achieve this. Not all the time unique identifier (such as Student Number) is available to search, sometimes we need to search by names and etc.
Anyone dealt with large volume of data can suggest anything?
Help would be much appreciated.
Thanks.