2 Replies Latest reply on Mar 22, 2010 11:20 PM by aehrensberger

    Recommended Indexes?

    aehrensberger

      During some recent work with a client, their DBAs suggested that we put the following indexes on the JBPM table...

       

      create index DOCFIN10U1.JBPM_PROCESSINSTANCE_N1 on DOCFIN10U1.JBPM_PROCESSINSTANCE(VERSION_, KEY_, START_, END_, ISSUSPENDED_, PROCESSDEFINITION_, ROOTTOKEN_, SUPERPROCESSTOKEN_, ID_);

       

      I'm very hesitant to add any indexes to JBPM tables when I would expect it to be optimized out of the box?  Is this not the case?  And does this index raise red flags for anybody else considering that it touches all the different columns in the PROCESSINSTANCE table?

       

      Thoughts?