Fixes Issue 29739. Adds Indexes for isProcess and IsCostCalculated columns
authorDavid Miguelez <david.miguelez@openbravo.com>
Thu, 11 Jun 2015 18:28:02 +0200
changeset 26901 2a66cd73cfe8
parent 26900 aba1a9d25e4d
child 26903 a14340555783
Fixes Issue 29739. Adds Indexes for isProcess and IsCostCalculated columns
to improve performance in Costing Background Process Queries.
src-db/database/model/tables/M_TRANSACTION.xml
--- a/src-db/database/model/tables/M_TRANSACTION.xml	Thu Jun 11 17:13:36 2015 +0200
+++ b/src-db/database/model/tables/M_TRANSACTION.xml	Thu Jun 11 18:28:02 2015 +0200
@@ -182,6 +182,9 @@
       <foreign-key foreignTable="M_PRODUCTIONLINE" name="M_TRANSACTION_M_PRODUCTIONLINE">
         <reference local="M_PRODUCTIONLINE_ID" foreign="M_PRODUCTIONLINE_ID"/>
       </foreign-key>
+      <index name="M_TRANSACTION_CALCULATED" unique="false">
+        <index-column name="ISCOSTCALCULATED"/>
+      </index>
       <index name="M_TRANSACTION_INOUTLINE" unique="false">
         <index-column name="M_INOUTLINE_ID"/>
       </index>
@@ -197,6 +200,9 @@
       <index name="M_TRANSACTION_MOVEMENTLINE" unique="false">
         <index-column name="M_MOVEMENTLINE_ID"/>
       </index>
+      <index name="M_TRANSACTION_PROCESSED" unique="false">
+        <index-column name="ISPROCESSED"/>
+      </index>
       <index name="M_TRANSACTION_PRODUCTIONLINE" unique="false">
         <index-column name="M_PRODUCTIONLINE_ID"/>
       </index>