diff --git a/web/org.openbravo.retail.posterminal/js/model/productcharacteristicvalue.js b/web/org.openbravo.retail.posterminal/js/model/productcharacteristicvalue.js
--- a/web/org.openbravo.retail.posterminal/js/model/productcharacteristicvalue.js
+++ b/web/org.openbravo.retail.posterminal/js/model/productcharacteristicvalue.js
@@ -1,6 +1,6 @@
 /*
  ************************************************************************************
- * Copyright (C) 2015 Openbravo S.L.U.
+ * Copyright (C) 2015-2016 Openbravo S.L.U.
  * Licensed under the Openbravo Commercial License version 1.0
  * You may obtain a copy of the License at http://www.openbravo.com/legal/obcl.html
  * or in the legal folder of this module distribution.
@@ -52,5 +52,16 @@
     type: 'TEXT'
   }]);
 
+  ProductCharacteristicValue.addIndex([{
+    name: 'm_ch_vl_prod_idx',
+    columns: [{
+      name: 'm_ch_value_id',
+      sort: 'desc'
+    }, {
+      name: 'm_product_id',
+      sort: 'desc'
+    }]
+  }]);
+
   OB.Data.Registry.registerModel(ProductCharacteristicValue);
 }());
\ No newline at end of file
