Related to issue 26239. Added an index to improve performance.
authorAntonio Moreno <antonio.moreno@openbravo.com>
Fri, 16 May 2014 10:05:06 +0200
changeset 23049 395765d96a1b
parent 23048 8a5e65e220e5
child 23050 c01179ac6783
child 23051 dbc986ded642
Related to issue 26239. Added an index to improve performance.
src-db/database/model/tables/AD_SESSION.xml
--- a/src-db/database/model/tables/AD_SESSION.xml	Fri May 16 05:19:10 2014 +0000
+++ b/src-db/database/model/tables/AD_SESSION.xml	Fri May 16 10:05:06 2014 +0200
@@ -87,6 +87,9 @@
       <index name="AD_SESSION_USER_IDX" unique="false">
         <index-column name="USERNAME"/>
       </index>
+      <index name="AD_SESSION_WEBSESSION_IDX" unique="false">
+        <index-column name="WEBSESSION"/>
+      </index>
       <check name="AD_SESSION_ACTIVE_CHK"><![CDATA[SESSION_ACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>