Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage. Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?
A.
Number of queries running at a time.
B.
Number of joins used in report query.
C.
Number of records returned by report query.
D.
Number of characters in report query.
B.
Number of joins used in report query.
C.
Number of records returned by report query.
Explanation:
B (Joins in report query): Reports with fewer object joins run faster, significantly reducing database load and improving responsiveness.
C (Records returned): Minimizing returned records (by applying selective filters) drastically reduces query execution time.
The number of queries or characters (A, D) doesn't directly correlate with report performance degradation as significantly as joins and record volume. Therefore, optimizing these two key factors ensures consistent performance even with extensive data volumes.