Fixed issue 37404. Added index to improve performance of C_IMPORT_ENTRY_ARCHIVE deletion.
authorAntonio Moreno <antonio.moreno@openbravo.com>
Sun, 03 Dec 2017 00:20:53 +0100
changeset 32425 267f4b5ebcb4
parent 32424 8c44968006a4
child 32426 b0850f8aa3fd
Fixed issue 37404. Added index to improve performance of C_IMPORT_ENTRY_ARCHIVE deletion.
src-db/database/model/tables/C_IMPORT_ENTRY_ARCHIVE.xml
--- a/src-db/database/model/tables/C_IMPORT_ENTRY_ARCHIVE.xml	Tue Nov 28 15:34:02 2017 +0100
+++ b/src-db/database/model/tables/C_IMPORT_ENTRY_ARCHIVE.xml	Sun Dec 03 00:20:53 2017 +0100
@@ -70,5 +70,8 @@
       <foreign-key foreignTable="AD_ORG" name="C_IMPORT_EA_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="C_IMPORT_ENTRY_ARCHIVE_IDX" unique="false">
+        <index-column name="CREATED"/>
+      </index>
     </table>
   </database>