activiti database index

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.

christoph_retti

Hello, is there some guide on which database index should be placed per default on a fresh activiti (5.10) installation.

I had some database locks and checked the (SQL Server 2008) database (found some hints here in the forum) and there is no index at all on the database

Maybe you could post a list of index you would recommend to have a starting place for me?

  regards, chris

jbarrez

No indexes?

I checked the activiti.mssql.create.engine.sql file and found these for the runtime alone:

<br>create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);<br>create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);<br>create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);<br>create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);<br>create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);<br>create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);<br>create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null;<br>create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);<br>
If you don't have any indexes, I'm afraid something has gone wrong there …