details: https://code.openbravo.com/erp/devel/pi/rev/74900cd513e1
changeset: 30311:74900cd513e1
user: Augusto Mauch <augusto.mauch <at> openbravo.com>
date: Fri Sep 23 12:15:25 2016 +0200
summary: Fixes issue 34072: Adds an index to c_bpartner_location.c_location_id
The index will prevent sequencial scans on c_bpartner_location when a query
like this is invoked:
SELECT *
FROM c_bpartner_location
WHERE c_location_id = ?
diffstat:
src-db/database/model/tables/C_BPARTNER_LOCATION.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r 38d87f5ca8e1 -r 74900cd513e1
src-db/database/model/tables/C_BPARTNER_LOCATION.xml
--- a/src-db/database/model/tables/C_BPARTNER_LOCATION.xml Thu Sep 22
10:40:12 2016 +0200
+++ b/src-db/database/model/tables/C_BPARTNER_LOCATION.xml Fri Sep 23
12:15:25 2016 +0200
@@ -103,6 +103,9 @@
<index name="C_BPLOCATION_BPARTNER" unique="false">
<index-column name="C_BPARTNER_ID"/>
</index>
+ <index name="C_BPLOCATION_LOCATION" unique="false">
+ <index-column name="C_LOCATION_ID"/>
+ </index>
<index name="C_BPLOCATION_UPDATED" unique="false">
<index-column name="UPDATED"/>
</index>
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
