Table optimization
Tables that are used with a large number of calculations have been observed as returning low performance.
Recommendations for table optimization
Schedule a weekly optimization for tables that are used in a large number of calculations. For information on how to add a task to a schedule please see our user guide documentation.
Open the Scheduler module, and select the Scheduler folder that you want to add a task to.
Click Add Task.
Set the task type to "Optimize".
Select "Some" so that you can then denote which tables you would like to run optimization for.
You can then set frequency for the optimization task.
Click Save.