Red Hat Bugzilla – Bug 1295498
Missing database indexes - I18NText.Notification_Names_Id, BAMTaskSummary.OPTLOCK
Last modified: 2016-03-24 09:26:24 EDT
+++ This bug was initially created as a clone of Bug #1279532 +++
Description of problem:
Hisao wrote in  that there are still missing database indexes for columns I18NText.Notification_Names_Id and BAMTaskSummary.OPTLOCK.
Index for column I18NText.Notification_Names_Id should be probably there (for all DB systems, not only Oracle), because it will be consistent with currently indexed columns from that table. However we don't have any OPTLOCK column indexed now and I don't know how it will behave in terms of performance if we create such index. Because of this and because of that 6.2 release is very close, I'm creating this new BZ so it can be also decided if this should be part of 6.2.0 or some later release.
Version-Release number of selected component (if applicable): 6.2.0.ER5
Verified with BPMS-6.3.0.ER1