Database Analysis

It is highly recommended that you setup a periodic job for database analysis. The frequency of the job depends on data volumes, frequency of change, and your IT policies. Consult your DBA.

It is recommended that analyze be run whenever the number of rows in various tables is changed by more than 10%.

Purge Historical Data

You can setup a periodic purge workflow to reduce the historical data.