topic Re: Act_Ru_Variable table indexes in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/act-ru-variable-table-indexes/m-p/101002#M70051 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Tue, 10 Apr 2012 17:48:04 GMT ronald_van_kuij 2012-04-10T17:48:04Z Act_Ru_Variable table indexes https://connect.hyland.com/t5/alfresco-archive/act-ru-variable-table-indexes/m-p/101001#M70050 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. Tue, 10 Apr 2012 14:45:16 GMT https://connect.hyland.com/t5/alfresco-archive/act-ru-variable-table-indexes/m-p/101001#M70050 erensimsek 2012-04-10T14:45:16Z Re: Act_Ru_Variable table indexes https://connect.hyland.com/t5/alfresco-archive/act-ru-variable-table-indexes/m-p/101002#M70051 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Tue, 10 Apr 2012 17:48:04 GMT https://connect.hyland.com/t5/alfresco-archive/act-ru-variable-table-indexes/m-p/101002#M70051 ronald_van_kuij 2012-04-10T17:48:04Z