Duplicate index on table act_procdef_info for column proc_def_id_

Description

The customer is using ACS 6.2.2 and they are using Postgresql 11.

The customer’s DB team performed a database audit and the audit result pointed out that there is this index columns duplicate, so this would impact performance of the database when updating the index and also memory consumption. The non-unique index is not needed, since the unique index covers the same column

From customer standpoint, this should be considered as product bug as it would impact Alfresco database performance.

Request:

Please remove the non-unique index *act_idx_procdef_info_proc*:

https://github.com/Alfresco/alfresco-community-repo/blob/master/repository/src/main/resources/alfresco/dbscripts/create/org.alfresco.repo.domain.dialect.PostgreSQLDialect/Schema-Reference-ACT.xml#L2005

Indeed, it is a duplicate of the unique index *act_uniq_info_procdef*:

https://github.com/Alfresco/alfresco-community-repo/blob/master/repository/src/main/resources/alfresco/dbscripts/create/org.alfresco.repo.domain.dialect.PostgreSQLDialect/Schema-Reference-ACT.xml#L2000

Environment

ACS 6.2.2, Postgresql 11

Testcase ID

None

Assignee

Unassigned

Reporter

Seng Ei Liaw

Labels

None

Escalated By

None

Security Issue

None

ACT Numbers

00363212

Premier Customer

Yes

Code Branch

None

Build Location

None

Regression Since

None

Work Funnel End

None

Patch Attached

None

Dependent Version/s

None

Cloud or Enterprise

None

Prioritization Score

None

Delivery Team

None

Bug Priority

Category 3

Components

Fix versions

Affects versions