How can custom reports be examined in order to determine how much data they will return?
Analytics, Analyzing report output
The report analyzer is designed to check the queries that a custom report makes on a site's database. This tool helps your custom reports run as quickly and efficiently as possible.
The report analyzer examines your report and provides suggestions as to how you can improve it by removing database tables, adding filters, and making other changes. The analyzer also shows you the estimated number of rows the report’s query may need to access so you know if the report can run without encountering row limits. Please note, this is an estimate only and the estimated number of rows can actually be much higher due to aggregate functions for example. The analyzer cannot return the exact number of rows because this would require it to run the entire query (which would defeat the purpose of analyzing the report before running it).
Report analyzer button in the ribbon
For additional information, refer to the 'Troubleshoot Reports with the Report Analyzer' section in the Online Help User Guide documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.