Handle huge Database data

Hi Team,

I am using database select query which is having more tha 10 lac records. Query is taking more than an hour to fetch the records. Is there any way to reduce the time and get the records quickly…?

Is there a reason you need so many records at once? Can you add more conditions to where clause to reduce number of results?

@TimK as per business logic i have to to that

You can try adding an index to the database to increase the performance of the sql if that is possible.

Does it take that long when you run it from sql manager?