fixed bug 27022: Sequential scans in ad_preference table
authorAsier Lostalé <asier.lostale@openbravo.com>
Mon, 07 Jul 2014 09:59:09 +0200
changeset 24170 0994ef60bf8c
parent 24169 9812b254f6a9
child 24171 0d33bb96c147
fixed bug 27022: Sequential scans in ad_preference table
src-db/database/model/tables/AD_PREFERENCE.xml
--- a/src-db/database/model/tables/AD_PREFERENCE.xml	Mon Jul 14 09:18:03 2014 +0200
+++ b/src-db/database/model/tables/AD_PREFERENCE.xml	Mon Jul 07 09:59:09 2014 +0200
@@ -101,6 +101,12 @@
       <foreign-key foreignTable="AD_WINDOW" name="AD_WINDOW_PREFERENCE" onDelete="cascade">
         <reference local="AD_WINDOW_ID" foreign="AD_WINDOW_ID"/>
       </foreign-key>
+      <index name="AD_PREFERENCE_ATTR_IDX" unique="false">
+        <index-column name="ATTRIBUTE"/>
+      </index>
+      <index name="AD_PREFERENCE_LIST_IDX" unique="false">
+        <index-column name="PROPERTY"/>
+      </index>
       <check name="AD_PREFERENCE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="AD_PREFERENCE_LIST_CHECK"><![CDATA[(((ISPROPERTYLIST = 'Y') AND (PROPERTY IS NOT NULL)) AND (ATTRIBUTE IS NULL)) OR (((ISPROPERTYLIST = 'N') AND (ATTRIBUTE IS NOT NULL)) AND (PROPERTY IS NULL))]]></check>
       <check name="AD_PREFERENCE_SELECTED_CHECK"><![CDATA[SELECTED IN ('Y', 'N')]]></check>