--在流程表上相应字段加上索引

drop index PROCESSINSTANCE_index;
drop index TASKINSTANCE_index;
drop index TASKMGMTINSTANCE_Index;
drop index token_index;
drop index JBPM_VARIABLE_INSTANCE_INDEX;
drop index JBPM_VARIABLE_MAP_INDEX;
drop index CONTEXTINSTANCE_index;

?

create index PROCESSINSTANCE_index on jbpm_moduleinstance (PROCESSINSTANCE_);
create index TASKINSTANCE_index on jbpm_comment(TASKINSTANCE_);
create index TASKMGMTINSTANCE_Index on jbpm_taskinstance(TASKMGMTINSTANCE_);
create index token_index on JBPM_COMMENT(token_);
create index JBPM_VARIABLE_INSTANCE_INDEX on JBPM_VARIABLEINSTANCE(TASKINSTANCE_);
create index JBPM_VARIABLE_MAP_INDEX on JBPM_VARIABLEINSTANCE(TOKENVARIABLEMAP_);
create index CONTEXTINSTANCE_index on JBPM_TOKENVARIABLEMAP(CONTEXTINSTANCE_);