From 8af4a5b81bdbd3d4c7dc3b4b7abe8948b23a2fbc Mon Sep 17 00:00:00 2001
From: Javier Etxarri <javier.echarri@openbravo.com>
Date: Wed, 17 Mar 2021 09:02:02 +0100
Subject: [PATCH] Related to issue NOE_3074: When getting properties, the query
 is improved adding and index in ispropertylist, it is 6-7 times faster

---
 src-db/database/model/tables/AD_PREFERENCE.xml | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/src-db/database/model/tables/AD_PREFERENCE.xml b/src-db/database/model/tables/AD_PREFERENCE.xml
index bd7100eee1..9143ad7dd6 100644
--- a/src-db/database/model/tables/AD_PREFERENCE.xml
+++ b/src-db/database/model/tables/AD_PREFERENCE.xml
@@ -111,6 +111,9 @@
       <index name="AD_PREFERENCE_ATTR_IDX" unique="false">
         <index-column name="ATTRIBUTE"/>
       </index>
+      <index name="AD_PREFERENCE_ISPRLIST_IDX" unique="false">
+        <index-column name="ISPROPERTYLIST"/>
+      </index>
       <index name="AD_PREFERENCE_LIST_IDX" unique="false">
         <index-column name="PROPERTY"/>
       </index>
-- 
2.27.0