[jboss-jira] [JBoss JIRA] Created: (JBPM-735) add indexes to foreign keys

Tom Baeyens (JIRA) jira-events at jboss.com
Thu Aug 17 05:08:39 EDT 2006


add indexes to foreign keys
---------------------------

                 Key: JBPM-735
                 URL: http://jira.jboss.com/jira/browse/JBPM-735
             Project: JBoss jBPM
          Issue Type: Feature Request
          Components: Core Engine
            Reporter: Tom Baeyens
         Assigned To: Tom Baeyens
             Fix For: jBPM 3.2 alpha 2


most databases don't generate implicit indexes for foreign keys.  so it's better to change the default and specify indexes on all foreign keys that can be used in joins.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        



More information about the jboss-jira mailing list