fixed bug 23934: sequential scan on AD_Session when logging in
authorAsier Lostalé <asier.lostale@openbravo.com>
Wed, 29 May 2013 12:16:05 +0200
changeset 20490 f6a4fd1a4a26
parent 20489 4057eab77422
child 20491 861974c450d8
fixed bug 23934: sequential scan on AD_Session when logging in
src-db/database/model/tables/AD_SESSION.xml
--- a/src-db/database/model/tables/AD_SESSION.xml	Tue May 28 13:09:46 2013 +0200
+++ b/src-db/database/model/tables/AD_SESSION.xml	Wed May 29 12:16:05 2013 +0200
@@ -75,6 +75,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_SESSION_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_SESSION_ACTIVE_IDX" unique="false">
+        <index-column name="SESSION_ACTIVE"/>
+      </index>
       <index name="AD_SESSION_CREATED_IDX" unique="false">
         <index-column name="CREATED"/>
       </index>