Fixes ISSUE-44324:Performance Regression after creating new index
author"atul.gaware" <atul.gaware@openbravo.com>
Thu, 02 Jul 2020 08:52:10 +0200
changeset 37465 de17990dba45
parent 37464 1ea52f3f801f
child 37466 1611c51ef2ae
Fixes ISSUE 44324:Performance Regression after creating new index
**Remove index fin_payment_documentno_id based on columns
documentno and fin_payment_id
src-db/database/model/tables/FIN_PAYMENT.xml
--- a/src-db/database/model/tables/FIN_PAYMENT.xml	Fri Jun 26 13:55:49 2020 +0000
+++ b/src-db/database/model/tables/FIN_PAYMENT.xml	Thu Jul 02 08:52:10 2020 +0200
@@ -191,10 +191,6 @@
         <index-column name="C_BPARTNER_ID"/>
         <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT,USED_CREDIT)"/>
       </index>
-      <index name="FIN_PAYMENT_DOCUMENTNO_ID" unique="false">
-        <index-column name="DOCUMENTNO"/>
-        <index-column name="FIN_PAYMENT_ID"/>
-      </index>
       <index name="FIN_PAYMENT_POSTED" unique="false">
         <index-column name="POSTED"/>
       </index>