details: https://code.openbravo.com/erp/devel/pi/rev/e7e49fefcf93 changeset: 35561:e7e49fefcf93 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Thu Mar 07 19:03:09 2019 +0530 summary: Fixes Issue 0039304: [SERQA 4539]: It would be nice have partial indexes for REPLACEDORDER_ID and REPLACEMENTORDER_ID columns in c_order table
** Added partial indexes for columns REPLACEDORDER_ID and REPLACEMENTORDER_ID in C_Order table. diffstat: src-db/database/model/tables/C_ORDER.xml | 8 ++++++++ 1 files changed, 8 insertions(+), 0 deletions(-) diffs (18 lines): diff -r 8fef3f886c45 -r e7e49fefcf93 src-db/database/model/tables/C_ORDER.xml --- a/src-db/database/model/tables/C_ORDER.xml Mon Mar 25 22:17:37 2019 -0300 +++ b/src-db/database/model/tables/C_ORDER.xml Thu Mar 07 19:03:09 2019 +0530 @@ -507,6 +507,14 @@ <index-column name="QUOTATION_ID"/> <whereClause><![CDATA[QUOTATION_ID IS NOT NULL]]></whereClause> </index> + <index name="C_ORDER_REPLACEDORDER" unique="false"> + <index-column name="REPLACEDORDER_ID"/> + <whereClause><![CDATA[REPLACEDORDER_ID IS NOT NULL]]></whereClause> + </index> + <index name="C_ORDER_REPLACEMENTORDER" unique="false"> + <index-column name="REPLACEMENTORDER_ID"/> + <whereClause><![CDATA[REPLACEMENTORDER_ID IS NOT NULL]]></whereClause> + </index> <index name="C_ORDER_SALESREP" unique="false"> <index-column name="SALESREP_ID"/> <whereClause><![CDATA[SALESREP_ID IS NOT NULL]]></whereClause> _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits