[jbpm-issues] [JBoss JIRA] Resolved: (JBPM-931) Create indexes for foreign keys in 3.1 branch

Create indexes for foreign keys in 3.1 branch --------------------------------------------- Key: JBPM-931 URL: http://jira.jboss.com/jira/browse/JBPM-931 Project: JBoss jBPM Issue Type: Bug Components: Core Engine Affects Versions: jBPM 3.1.4, jBPM 3.1.3, jBPM 3.1.2, jBPM 3.1.1, jBPM 3.1 Reporter: David Lloyd Assigned To: Tom Baeyens Many users are using jBPM 3.1.x and do not have the ability to perform a major upgrade. However 3.1.x suffers from a significant problem in that many foreign keys do not have indexes (this problem was fixed for 3.2.0). This causes queries against these keys to scan the full table. In the case of database which use row locks for both reads and writes, this can lead to deadlock scenarios because many, many rows are locked unnecessarily. Tables are frequently queried by their foreign keys; that's why they exist. Therefore these columns should be indexed. (Relates to JBPM-735)