topic Re: Full Table Scan for ACT_HI_PROCINST in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/full-table-scan-for-act-hi-procinst/m-p/192178#M145308 <HTML><HEAD></HEAD><BODY><SPAN>Indices are always a trade off between insert speed and query speed. If you need more performance for querying, feel free to add the appropriate indices that speed up your use cases.</SPAN></BODY></HTML> Tue, 02 Jun 2015 18:45:43 GMT jbarrez 2015-06-02T18:45:43Z Full Table Scan for ACT_HI_PROCINST https://connect.hyland.com/t5/alfresco-archive/full-table-scan-for-act-hi-procinst/m-p/192177#M145307 Hi,Following query is performing Full table scan on ACT_HI_PROCINST which impacting the performance of Application&nbsp; Can you&nbsp; suggest any index we can Create&nbsp; on SUPER_PROCESS_INSTANCE_ID_ column and also what kind of index creation will increases the performance of sql query execution ?SQL Query : s Mon, 25 May 2015 11:45:11 GMT https://connect.hyland.com/t5/alfresco-archive/full-table-scan-for-act-hi-procinst/m-p/192177#M145307 sakumar1 2015-05-25T11:45:11Z Re: Full Table Scan for ACT_HI_PROCINST https://connect.hyland.com/t5/alfresco-archive/full-table-scan-for-act-hi-procinst/m-p/192178#M145308 <HTML><HEAD></HEAD><BODY><SPAN>Indices are always a trade off between insert speed and query speed. If you need more performance for querying, feel free to add the appropriate indices that speed up your use cases.</SPAN></BODY></HTML> Tue, 02 Jun 2015 18:45:43 GMT https://connect.hyland.com/t5/alfresco-archive/full-table-scan-for-act-hi-procinst/m-p/192178#M145308 jbarrez 2015-06-02T18:45:43Z