Report performance best practices

This page documents the impact and remediation activities for issues on a Salesforce Report (Configuration element type is Report).

Best PracticeIssue SeverityImpact AreaImpactRemediation
The show filter should not contain the "All" option High PerformanceRetrieving unnecessary data is always inefficient and slows down performanceWhenever you can, choose the My... or My Team's... options rather than All in the "Show" filter.   
The "contains" and "does not contain" filter operators should not be used Medium PerformanceSelective filters generally work faster than more general ones, all else being equal. Try to make your filters as selective as you can.Use the equals or not equal to operators instead of contains or does not contain.
The "or" operator should not be used Medium PerformanceSelective filters generally work faster than more general ones, all else being equal. Try to make your filters as selective as you can.Choose AND rather than OR for filter logic.
Unbounded time intervals should not be used Medium PerformanceFailing to narrow the time period for a report is very likely to cause performance issues.Always use the starting and ending date values to limit the report scope.  
Bounded relative date values should be used whenever appropriate Medium PerformanceUsing open-ended time range queries in Reports can significantly impact their performance.

Try using relative date values such as THIS WEEK, NEXT MONTH, or TOMORROW. This works well for saved reports for a specific, but relative time period—for example, Last Month’s Leads.

Details should not be shown by default  Medium PerformanceRetrieving unnecessary data is always inefficient and slows down performance.Select Hide Details in Advanced Filters if you only need a summary of the data and to reduce loading time.  
The number of fields on a report should be kept to a minimum    Warning    PerformanceRetrieving unnecessary data is always inefficient and slows down performance.Exclude unnecessary columns. This is especially effective if you’re using a summary or matrix report and have Show Details enabled.