Act_Ru_Variable table indexes

[erensimsek]

Hello,

There is no index on TASK_ID_ column on ACT_RU_VARIABLE table, is there any special reason?

I suggest creating index ACT_IDX_VAR_TASK on ACT_RU_VARIABLE..

create index ACTIVITI.ACT_IDX_VAR_TASK on ACTIVITI.ACT_RU_VARIABLE (TASK_ID_)


What do you think?

Thank you.

[ronald_van_kuij]

Activiti only contains 'basic' indexes or ones one queries that are used by the core engine. Other queries can be optimized at your own discretion (other users need other queries, so other optimizations). If the core activiti would contain to many idexes, it would slow down to much, so feel free to add it yourself.