Index: src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java
===================================================================
diff -u -r5abc4d6ebfe182ceed275d7f21d09900329101d3 -rdab2aac3f1e86b3ea9d4da2e1452ff75718eaa04
--- src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision 5abc4d6ebfe182ceed275d7f21d09900329101d3)
+++ src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision dab2aac3f1e86b3ea9d4da2e1452ff75718eaa04)
@@ -176,7 +176,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 ";
             }