Bug 1295498

Summary: Missing database indexes - I18NText.Notification_Names_Id, BAMTaskSummary.OPTLOCK
Product: [Retired] JBoss BPMS Platform 6 Reporter: Alessandro Lazarotti <alazarot>
Component: jBPM CoreAssignee: Alessandro Lazarotti <alazarot>
Status: CLOSED EOL QA Contact: Radovan Synek <rsynek>
Severity: high Docs Contact:
Priority: high    
Version: 6.2.0CC: alazarot, hfuruich, kverlaen, lpetrovi, tzimanyi
Target Milestone: ER1   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 1279532 Environment:
Last Closed: 2020-03-27 20:11:49 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1279532    
Bug Blocks:    

Description Alessandro Lazarotti 2016-01-04 17:31:00 UTC 
+++ 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 13:26:24 UTC 
Verified with BPMS-6.3.0.ER1