Bug 1295498 - Missing database indexes - I18NText.Notification_Names_Id, BAMTaskSummary.OPTLOCK
Missing database indexes - I18NText.Notification_Names_Id, BAMTaskSummary.OPT...
Product: JBoss BPMS Platform 6
Classification: JBoss
Component: jBPM Core (Show other bugs)
Unspecified Unspecified
high Severity high
: ER1
: 6.3.0
Assigned To: Maciej Swiderski
Radovan Synek
Depends On: 1279532
  Show dependency treegraph
Reported: 2016-01-04 12:31 EST by Alessandro Lazarotti
Modified: 2016-03-24 09:26 EDT (History)
5 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 1279532
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Alessandro Lazarotti 2016-01-04 12:31:00 EST
+++ This bug was initially created as a clone of Bug #1279532 +++

Description of problem:

Hisao wrote in [1] 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

Additional info: 

[1] https://bugzilla.redhat.com/show_bug.cgi?id=1049238
Comment 2 Radovan Synek 2016-03-24 09:26:24 EDT
Verified with BPMS-6.3.0.ER1

Note You need to log in before you can comment on or make changes to this bug.