topic Re: Database indexes missing? on Alfresco 2.1 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/database-indexes-missing-on-alfresco-2-1/m-p/187492#M140622 <HTML><HEAD></HEAD><BODY><SPAN>For reference, which DB type are you using ?</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Jan</SPAN></BODY></HTML> Tue, 09 Sep 2008 08:12:30 GMT janv 2008-09-09T08:12:30Z Database indexes missing? on Alfresco 2.1 https://connect.hyland.com/t5/alfresco-archive/database-indexes-missing-on-alfresco-2-1/m-p/187491#M140621 We are using Alfresco 2.1 (community edition) to handle a repository of several million documents.&nbsp; In the process of loading data, we found several indexes missing from the database, whose absence was causing some full table scans, and hence significantly slowing processing. This did not noticeably Mon, 08 Sep 2008 18:23:07 GMT https://connect.hyland.com/t5/alfresco-archive/database-indexes-missing-on-alfresco-2-1/m-p/187491#M140621 dwarren 2008-09-08T18:23:07Z Re: Database indexes missing? on Alfresco 2.1 https://connect.hyland.com/t5/alfresco-archive/database-indexes-missing-on-alfresco-2-1/m-p/187492#M140622 <HTML><HEAD></HEAD><BODY><SPAN>For reference, which DB type are you using ?</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Jan</SPAN></BODY></HTML> Tue, 09 Sep 2008 08:12:30 GMT https://connect.hyland.com/t5/alfresco-archive/database-indexes-missing-on-alfresco-2-1/m-p/187492#M140622 janv 2008-09-09T08:12:30Z Re: Database indexes missing? on Alfresco 2.1 https://connect.hyland.com/t5/alfresco-archive/database-indexes-missing-on-alfresco-2-1/m-p/187493#M140623 <HTML><HEAD></HEAD><BODY><SPAN>We're using Oracle 10g.</SPAN></BODY></HTML> Wed, 10 Sep 2008 16:26:55 GMT https://connect.hyland.com/t5/alfresco-archive/database-indexes-missing-on-alfresco-2-1/m-p/187493#M140623 dwarren 2008-09-10T16:26:55Z