The results can be displayed in more than 80 prepackaged reports and graphs that give you an immediate and comprehensive understanding of your reporting environment. These requests use excessive resources and result in long waits for consumers. Target these requests for optimization first. Joining too many tables is expensive and slow. Stage data from many tables into one for better performance and navigability.
Aggregations can cause a bottleneck during query execution.
Improve performance by pre-calculating the aggregations and staging them in summary tables. Poor selection criteria. Indexes increase selection speeds but impede update and insertion performance. Identify those fields that really need to be indexed and eliminate those that don't. Times of heaviest workload.