I have a report program which has a performance issue. When the user runs the program online, it is taking more time to execute .
When I check the Runtime Analysis for the report, there are two select statements which are taking consuming the highest time in the report. For the Select statements are using For All Entries. Since the User doesn't input any data and run the program for all the data, it has almost 15000 entries which is causing the "Select .. for all entries" to consume lot of time.
Please let me know if there is any work around for this issue.
Thanks in advance!!