topic Re: Full Table Scan Happening for the table ACT_HI_PROCINST in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/full-table-scan-happening-for-the-table-act-hi-procinst/m-p/218716#M171846 <HTML><HEAD></HEAD><BODY><SPAN>The only place where I could find this, is in the regular HistoricProcessInstanceQuery.</SPAN><BR /><SPAN>The history tables have by default no indices applied (for insert speed), so adding one on SUPER_PROCESS_INSTANCE_ID_ might solve it in this case.</SPAN></BODY></HTML> Tue, 08 Dec 2015 19:51:56 GMT jbarrez 2015-12-08T19:51:56Z Full Table Scan Happening for the table ACT_HI_PROCINST https://connect.hyland.com/t5/alfresco-archive/full-table-scan-happening-for-the-table-act-hi-procinst/m-p/218715#M171845 Hi,We are using Activiti 5.17Below Query causing full table scan of ACT_HI_PROCINST resulting in slowing down the performance.select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_PROCINST RES WHERE RES.SUPER_PROCESS_INSTANCE_ID_ = :1 order by RES.ID_ asc ) a where ROWNUM &lt; :2 ) Mon, 07 Dec 2015 14:21:52 GMT https://connect.hyland.com/t5/alfresco-archive/full-table-scan-happening-for-the-table-act-hi-procinst/m-p/218715#M171845 sakumar1 2015-12-07T14:21:52Z Re: Full Table Scan Happening for the table ACT_HI_PROCINST https://connect.hyland.com/t5/alfresco-archive/full-table-scan-happening-for-the-table-act-hi-procinst/m-p/218716#M171846 <HTML><HEAD></HEAD><BODY><SPAN>The only place where I could find this, is in the regular HistoricProcessInstanceQuery.</SPAN><BR /><SPAN>The history tables have by default no indices applied (for insert speed), so adding one on SUPER_PROCESS_INSTANCE_ID_ might solve it in this case.</SPAN></BODY></HTML> Tue, 08 Dec 2015 19:51:56 GMT https://connect.hyland.com/t5/alfresco-archive/full-table-scan-happening-for-the-table-act-hi-procinst/m-p/218716#M171846 jbarrez 2015-12-08T19:51:56Z