Maintenance and Tuning:
The following table describes example commands for specific databases. These commands are for illustration only. You must validate the commands required for your environment with your DBA.
|Database||Example maintenance commands|
|MySQL||ANALYZE - consult with an experienced, certified MySQL DBA who has InnoDB
experience (Alfresco Community Edition cannot
use a MyISAM database and hence an InnoDB-experienced MySQL DBA is required).
Refer to the following link: https://dev.mysql.com/doc/refman/5.6/en/analyze-table.html.
|PostgreSQL||VACUUM and ANALYZE – consult with an experienced, certified PostgreSQL DBA.
Refer to the following link: https://www.postgresql.org/docs/10/maintenance.html.
|Oracle||Depends on version – consult with an experienced, certified Oracle DBA.
Refer to the following link: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431.
|Microsoft SQL Server||ALTER INDEX
UPDATE STATISTICS (Transact-SQL)
Consult with an experienced, certified MS SQL Server DBA