As shown in the IXSCAN descriptor in Figure 8, the leading column of the index exploited by optimizer is PRODUCT_NUMBER, which does not provide the order required for merge scan join.
Each index can be specified using the @index annotation in an Entity class or by using the HashIndex plug-in configuration in an ObjectGrid descriptor XML file.