We have a RD fetching millions of records based on 5 filters specified in it but its working very slow?How to resolve this
Use as much equals condition as possible, check use null if empty checkbox, do not read from BLOBs, generate expense plan by taking the SQL that is being generated from the report and analyzing that to see where its taking time.
@TanyaS58 - Make sure the properties are optimized to get the data faster.
Thank you.