Reference: Improving Report Performance

Data Source Processing Mode

Indexed

processing mode results in the best report performance. Ensure that the

Data Source Processing Mode

is

Indexed

by:

Creating a report with an indexed data source.
Selecting the
Optimized for Performance
check box when you create a report to limit your report to indexed fields.

Filter Processing Mode

Indexed

processing mode results in the best report performance. Access the

View Indexed Fields for Data Source

report to ensure that the fields you use to filter the report are indexed for filtering. If needed, replace nonindexed fields with indexed fields.

Filter Processing Mode

Some fields in an indexed data source aren't indexed for all usages. If you're using an indexed data source and your report still runs slowly, you can:

Access the
View Indexed Fields for Data Source
report to confirm that the fields in your report are indexed for filters, facets, aggregation, and group by.
Replace nonindexed fields with indexed fields.

Data Source Instance Count

If the

Report Instance Count

is much less than the

Data Source Instant Count

, consider using a more focused data source to improve report performance.