details: https://code.openbravo.com/erp/devel/pi/rev/82f92b9d402a
changeset: 34758:82f92b9d402a
user: Mark <markmm82 <at> gmail.com>
date: Mon Aug 27 21:12:20 2018 -0400
summary: Related to issue 39158: Added missing indexes to improve performance
Created new indexes to improve performance.
diffstat:
src-db/database/model/tables/FACT_ACCT.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r bc3da89075bb -r 82f92b9d402a src-db/database/model/tables/FACT_ACCT.xml
--- a/src-db/database/model/tables/FACT_ACCT.xml Wed Sep 05 18:19:38
2018 +0200
+++ b/src-db/database/model/tables/FACT_ACCT.xml Mon Aug 27 21:12:20
2018 -0400
@@ -292,6 +292,9 @@
<index-column name="C_ACCTSCHEMA_ID"/>
<index-column name="ACCOUNT_ID"/>
</index>
+ <index name="FACT_ACCT_ACCOUNT_IDX" unique="false">
+ <index-column name="ACCOUNT_ID"/>
+ </index>
<index name="FACT_ACCT_BPARTNER" unique="false">
<index-column name="C_BPARTNER_ID"/>
<whereClause><![CDATA[C_BPARTNER_ID IS NOT NULL]]></whereClause>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
