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 - Update statistics and defragment indexes in the database and remove temporary data. This operation is performed regularly automatically. 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.

    note

    To optimize performance, you need to have Alvao Service installed.

  • 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.