Update database indexes


  • You might face a requirement where you need to update your database indexes, such as during an upgrade process or a database migration process


  • Liferay DXP 7.0+


  • Up until Liferay DXP 7.3:
    • setting the database.indexes.update.on.startup=true property in the portal-ext.properties will update the indexes for core tables such as User, ResourcePermission, etc., but not for module tables
    • therefore, you will have to run the updateIndexesAll from the GoGo shell in order to update all indexes
  • From Liferay DXP 7.4:
    • LPS-109189 has been implemented and so the database.indexes.update.on.startup property will cover both core and module tables as well
  • Please note that, we only delete the obsolete indexes and create the missed ones, we do not regenerate all indexes


Este artigo foi útil?
Utilizadores que acharam útil: 0 de 0