Bug 1295498 - Missing database indexes - I18NText.Notification_Names_Id, BAMTaskSummary.OPTLOCK
Summary: Missing database indexes - I18NText.Notification_Names_Id, BAMTaskSummary.OPT...
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: jBPM Core
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ER1
: 6.3.0
Assignee: Alessandro Lazarotti
QA Contact: Radovan Synek
URL:
Whiteboard:
Depends On: 1279532
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-01-04 17:31 UTC by Alessandro Lazarotti
Modified: 2020-03-27 20:11 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of: 1279532
Environment:
Last Closed: 2020-03-27 20:11:49 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

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
Note You need to log in before you can comment on or make changes to this bug.