Bug 1008333

Summary: Impact of Indices applied on JBPM tables
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: jadhavpprasad
Component: JBPM - within SOAAssignee: Nobody <nobody>
Status: NEW --- QA Contact:
Severity: high Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: jadhavpprasad, soa-p-jira
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Task
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description jadhavpprasad 2013-09-16 07:55:42 UTC 
I found deadlock issue while deleting process instance in multi-user environment.
As suggested one of the forum of RED-HAT i have created indices. here is URL of forum
https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_SOA_Platform/4.2/html/4.2.CP04_Release_Notes/sect-manually_create_jBPM_indexes_when_upgrading.html

After applying these indices deadlock issue resolved for me.

My questions are:
1. How much database size will increase after applying these indices?
2. What will be impact on insertion operations such as Create Process Instance and Execute Transitions operations?