The BPMS 6.4 Installation Guide - Chapter 3. Persistence Setups - contains instructions on how to prepare the database, using the provided ddl scripts.

The same is missing in the RHPAM 7.x Installation Guides.

Since it is critical for production environments that the database schema is created using the provided ddl scripts (which contain the necessary indexes), the relevant instructions need to be added to the RHPAM 7.x docs as well. The instructions should contain a note highlighting that using the ddl scripts to set up the database schema is mandatory in a production environment, and failing to do so will result in degraded performance due to missing indexes.

RHPAM: CONFIGURING JDBC DATA SOURCES FOR PROCESS SERVER.

Pull request