Fixes BUG-44342:Created index for Financial account
authorAtul Gaware <atul.gaware@openbravo.com>
Sat, 20 Jun 2020 21:28:47 +0530
changeset 37454 96e85683b865
parent 37452 e8e21dee39c4
child 37455 fef95dbc12f8
Fixes BUG 44342:Created index for Financial account
window performance does not work efficiently if there
are no reconciliations

**Added index on column FIN_FINANCIAL_ACCOUNT_ID, CREATED in
same order instead of order CREATED, FIN_FINANCIAL_ACCOUNT_ID
**Added index on column CREATED
src-db/database/model/tables/FIN_RECONCILIATION.xml
--- a/src-db/database/model/tables/FIN_RECONCILIATION.xml	Fri Jun 12 14:29:07 2020 +0200
+++ b/src-db/database/model/tables/FIN_RECONCILIATION.xml	Sat Jun 20 21:28:47 2020 +0530
@@ -97,12 +97,12 @@
       <foreign-key foreignTable="FIN_FINANCIAL_ACCOUNT" name="FIN_RECONCIL_FINFINANCIALACC">
         <reference local="FIN_FINANCIAL_ACCOUNT_ID" foreign="FIN_FINANCIAL_ACCOUNT_ID"/>
       </foreign-key>
-      <index name="FIN_RECONCILE_CREATED_FINACC" unique="false">
+      <index name="FIN_RECONCILE_CREATED" unique="false">
         <index-column name="CREATED"/>
+      </index>
+      <index name="FIN_RECONCILE_FINACC_CREATED" unique="false">
         <index-column name="FIN_FINANCIAL_ACCOUNT_ID"/>
-      </index>
-      <index name="FIN_RECONCILE_FINACCOUNT" unique="false">
-        <index-column name="FIN_FINANCIAL_ACCOUNT_ID"/>
+        <index-column name="CREATED"/>
       </index>
       <index name="FIN_RECONCILIATION_POSTED" unique="false">
         <index-column name="POSTED"/>