details: https://code.openbravo.com/erp/devel/pi/rev/b7b5576137de
changeset: 32673:b7b5576137de
user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
date: Wed Sep 13 09:17:21 2017 +0200
summary: Related to issue 36789: Use partial index
diffstat:
src-db/database/model/tables/FACT_ACCT.xml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r eaf73138f70a -r b7b5576137de src-db/database/model/tables/FACT_ACCT.xml
--- a/src-db/database/model/tables/FACT_ACCT.xml Tue Sep 12 21:41:29
2017 +0530
+++ b/src-db/database/model/tables/FACT_ACCT.xml Wed Sep 13 09:17:21
2017 +0200
@@ -294,6 +294,7 @@
</index>
<index name="FACT_ACCT_BPARTNER" unique="false">
<index-column name="C_BPARTNER_ID"/>
+ <whereClause><![CDATA[C_BPARTNER_ID IS NOT NULL]]></whereClause>
</index>
<index name="FACT_ACCT_DATEACCT" unique="false">
<index-column name="DATEACCT"/>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits