# HG changeset patch
# User Martin Taal <martin.taal@openbravo.com>
# Date 1412545351 -7200
# Node ID 8c50f1c82554d7e742d38d829be216c567cf9e1d
# Parent  d6a93f11736d56495950ac35b282d0edf7743b59
Related to issue 27766: Improve performance, add index to OBPOS_APP_CASH_RECONCIL
add index on payment id to prevent full table scans

diff -r d6a93f11736d -r 8c50f1c82554 src-db/database/model/tables/OBPOS_APP_CASH_RECONCIL.xml
--- a/src-db/database/model/tables/OBPOS_APP_CASH_RECONCIL.xml	Fri Oct 03 14:08:27 2014 +0200
+++ b/src-db/database/model/tables/OBPOS_APP_CASH_RECONCIL.xml	Sun Oct 05 23:42:31 2014 +0200
@@ -63,6 +63,9 @@
       <index name="OBPOS_APP_CASH_REC_CASHUP_IDX" unique="false">
         <index-column name="OBPOS_APP_CASHUP_ID"/>
       </index>
+      <index name="OBPOS_APP_CASH_REC_PAYMNT_IDX" unique="false">
+        <index-column name="OBPOS_APP_PAYMENT_ID"/>
+      </index>
       <check name="OBPOS_APPCASHREC_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>