topic Re: Full Table Scan of ACT_RU_JOB RES in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/full-table-scan-of-act-ru-job-res/m-p/209072#M162202 <HTML><HEAD></HEAD><BODY><SPAN>You can add whatever indices you want. However, it surprises me RETRIES and EXCLUSIVE is part of your index. They typically are true/false and 1/2/3 … so not very good candidate for an index …</SPAN></BODY></HTML> Sat, 28 Feb 2015 09:28:32 GMT jbarrez 2015-02-28T09:28:32Z Full Table Scan of ACT_RU_JOB RES https://connect.hyland.com/t5/alfresco-archive/full-table-scan-of-act-ru-job-res/m-p/209071#M162201 In our performance setup below query is making full table scan we see this could be the issue with index on.Can you please&nbsp; let us know we can create the composite&nbsp; index on table ACT_RU_JOB&nbsp; columns (EXCLUSIVE_,PROCESS_INSTANCE_ID_,RETRIES_)?select * from ( select a.*, ROWNUM rnum from (&nbsp;&nbsp;&nbsp;&nbsp; select Wed, 25 Feb 2015 07:17:29 GMT https://connect.hyland.com/t5/alfresco-archive/full-table-scan-of-act-ru-job-res/m-p/209071#M162201 sakumar1 2015-02-25T07:17:29Z Re: Full Table Scan of ACT_RU_JOB RES https://connect.hyland.com/t5/alfresco-archive/full-table-scan-of-act-ru-job-res/m-p/209072#M162202 <HTML><HEAD></HEAD><BODY><SPAN>You can add whatever indices you want. However, it surprises me RETRIES and EXCLUSIVE is part of your index. They typically are true/false and 1/2/3 … so not very good candidate for an index …</SPAN></BODY></HTML> Sat, 28 Feb 2015 09:28:32 GMT https://connect.hyland.com/t5/alfresco-archive/full-table-scan-of-act-ru-job-res/m-p/209072#M162202 jbarrez 2015-02-28T09:28:32Z