Database/Table optimization

When running the update.php or setupStore.php script it is generally not recommended to disable the table optimization (see  option) in order to ensure that the RDMBS query planner uses the most recent table statistics to make a best effort when selecting query paths.

Of course, if your wiki has a general maintenance window for activities like running table optimizations then it is recommended to postpone those tasks to the preferred time.