[jboss-user] [jBPM] - Recommended Indexes?

[aaron ehrensberger]

aaron ehrensberger [http://community.jboss.org/people/aehrensberger] created the discussion

"Recommended Indexes?"

To view the discussion, visit: http://community.jboss.org/message/533291#533291

--------------------------------------------------------------
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?

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/533291#533291]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100322/4c042ef1/attachment.html