Index: src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java
===================================================================
diff -u -r3a359d30d3bb8722659969e1dbd6a5f61cb79776 -r5509b842a40b673e8cb92bf3c96f3f25343e108e
--- src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision 3a359d30d3bb8722659969e1dbd6a5f61cb79776)
+++ src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision 5509b842a40b673e8cb92bf3c96f3f25343e108e)
@@ -174,7 +174,7 @@
                             " AND sim_sp.site_id IN (SELECT site_id FROM session_site WHERE session_id = " + skuTableWidgetData.getSessionId() + ")" +
                             " AND sp.product_id = sim.product_id AND sim.similar_product_id = sim_sp.product_id ) similarproduct ";
                 else
-                    sql += " , SIMILAR_PRODUCT similarproduct , (SELECT DISTINCT product_id FROM site_product WHERE site_id IN" +
+                    sql += " , SIMILAR_PRODUCT similarproduct , (SELECT DISTINCT /*+ no_index(site_product) */ product_id FROM site_product WHERE site_id IN" +
                             " (SELECT site_id FROM session_site WHERE session_id = " + skuTableWidgetData.getSessionId() + ")) sp ";
             }