Add default indexes on RT Join Tables for fields in the reporting schema

You can add a default index to any RT Join table in the database through the Create RPS Join Default Index on Fields setting.

Before configuring this setting, complete the following tasks:

  • Review this task with your database administrator and IBM® Support.
  • Test the change by manually creating the index in the database before making a permanent change in IBM OpenPages®.

You can create a string up to 4000 characters.

Configure this setting only after careful analysis of your data query patterns. Adding too many indexes to a table can degrade performance.

After modifying this registry entry, you can implement your index changes by re-creating the reporting schema.

Platform > Reporting Schema > Create RPS Join Default Index on Fields
Default: true.
Values: true, false.
If RPS is regenerated after the option is set to true, all RT Join tables will have default indexes created, as seen below:
CREATE INDEX IX_OBJ_23_JOIN ON rt__entity_file(reporting_period_id,entity_id,file_id,is_primary,distance) 
CREATE INDEX IX_OBJ_24_JOIN ON rt__issue_file(reporting_period_id,issue_id,file_id,is_primary,distance) 
CREATE INDEX IX_OBJ_25_JOIN ON rt__actionitem_file(reporting_period_id,actionitem_id,file_id,is_primary,distance) 
CREATE INDEX IX_OBJ_27_JOIN ON rt__project_entity(reporting_period_id,project_id,entity_id,is_primary,distance) 
CREATE INDEX IX_OBJ_28_JOIN ON rt__entity_entity(reporting_period_id,p_entity_id,c_entity_id,is_primary,distance)