Act_Ru_Variable table indexes

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.