Optimization operation
Incentives offers an Optimize Model feature that targets all user-created data, custom and structural tables and associated history tables for a database full statistics update operation.
Importance of table statistics
Statistics on a table provide information on how the data is distributed.
During calculation runs, Incentives submits queries, and the database uses these statistics to determine the most efficient way to retrieve and aggregate the data.
Regularly updating statistics ensures that the database processes queries in an optimal manner, leading to improved performance.
Recommendation for running statistics updates
Frequency considerations
Running the optimization operation daily is generally excessive.
However, in scenarios where day-to-day data volumes and fluctuations are high, more frequent updates may be necessary.
Suggested schedule
Start by running the operation weekly in QA/UAT/PERF environments and monitor optimization and model computation times.
Consider switching to a biweekly schedule and compare the results to determine if there is any improvement or decline in optimization and computation efficiency.