Fixed 25682: Add index on c_invoice.c_order_id to speedup triggers
authorStefan Hühner <stefan.huehner@openbravo.com>
Fri, 07 Feb 2014 12:56:56 +0100
changeset 21999 37e75d99da04
parent 21998 360a837f23db
child 22000 c0a400dc48bd
Fixed 25682: Add index on c_invoice.c_order_id to speedup triggers
c_order_trg & c_order_trg2
src-db/database/model/tables/C_INVOICE.xml
--- a/src-db/database/model/tables/C_INVOICE.xml	Thu Feb 06 11:27:59 2014 +0100
+++ b/src-db/database/model/tables/C_INVOICE.xml	Fri Feb 07 12:56:56 2014 +0100
@@ -357,6 +357,9 @@
       <index name="C_INVOICE_DOCNO" unique="false">
         <index-column name="DOCUMENTNO"/>
       </index>
+      <index name="C_INVOICE_ORDER" unique="false">
+        <index-column name="C_ORDER_ID"/>
+      </index>
       <index name="C_INVOICE_UPDATED" unique="false">
         <index-column name="UPDATED"/>
       </index>