Skip to main content

Database maintenance

Options:

  • Refresh data for reports - adds custom fields and object properties to the database views in the Query schema, which are used for data analysis and reporting. This update does not need to be done before each analysis or report, but only after adding new custom fields or object properties.

  • Optimize performance - updates statistics and defragments indexes in the database and removes temporary data.

    This operation is performed automatically regularly on every Sunday between 3:00 am and 3:55 am. Automatic maintenance will only start if more than 5 days have passed since the last optimization.

    Use this command only if the database performance has dropped and the Alvao system is slowed down.

    warning

    We do not recommend optimizing performance during system uptime, as it can take several minutes and applications may stop responding during that time.

  • Repair database - Recalculate precomputed values in the database, such as auxiliary tables of language localizations, paths in the object tree (AM), object names generated from property values (AM), etc. This command is for emergency situations only and does not need to be run regularly.