Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?
A.
Use triggers to populate denormalized related fields on the Account.
B.
Use an indexed data field with bounded data filters.
C.
Use Formula fields to surface information I related entities on the report.
D.
Use unbounded date ranges to filter the report.
A.
Use triggers to populate denormalized related fields on the Account.
B.
Use an indexed data field with bounded data filters.
Explanation:
Option A ("Use triggers to populate denormalized related fields on Account") increases report performance significantly by reducing joins at runtime.
Option B ("Use indexed data field with bounded data filters") leverages indexed fields and constrained data ranges to optimize query performance.
Using formula fields (C) on large volumes of data negatively impacts performance, and unbounded date ranges (D) harm performance by scanning huge datasets unnecessarily.