Update database indexes

Issue

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

Environment

• Liferay DXP 7.0+

Resolution

• 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