Index: src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java
===================================================================
diff -u -r3a359d30d3bb8722659969e1dbd6a5f61cb79776 -r5abc4d6ebfe182ceed275d7f21d09900329101d3
--- 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 5abc4d6ebfe182ceed275d7f21d09900329101d3)
@@ -114,8 +114,10 @@
                 {  site_type = true;}
                 break;
             }
+            String hintForSessionSiteProduct = isFinalized? "": " /*+ no_index(ssp) */ ";
+
             String sql = " SELECT \"productId\", \"sku\", \"description\", \"perCar\", \"introDate\",\"prolinkNational\",\"prolinkDc\",\"prolinkSite\", \"topApp\", \"salesPotential\",\"dcrPts\",\"businessRulesApplied\",\"stdPack\", \"avgAge\", \"groupCode\", \"nationalVIO\", \"national12\", \"national24\", \"reviewed\", \"approxSize\",\"skucost\",  RN FROM "
-                    + "(select  /*+ no_index(ssp) */ P.PRODUCT_ID AS \"productId\", (P.FIELD_ABBR || ' ' || P.EXT_PART_NUMBER) AS \"sku\",  P."
+                    + "(select  " + hintForSessionSiteProduct + " P.PRODUCT_ID AS \"productId\", (P.FIELD_ABBR || ' ' || P.EXT_PART_NUMBER) AS \"sku\",  P."
                     + (("en".equals(user.getLanguage()) || user.getLanguage() == null) ? "PRODUCT_DESC" : "PRODUCT_DESC_FR")
                     + " AS \"description\", "
                     + " P.PER_CAR AS \"perCar\",  P.INTRO_DT AS \"introDate\", " + query3 + " AS \"prolinkNational\"," + query + "as \"prolinkDc\"," + query2 + "as \"prolinkSite\",P.TOP_APP AS \"topApp\", NVL(MAX(ROUND(ssp.PTS*100)),0) AS \"salesPotential\", MAX(ROUND(ssp.DCR_PTS,2)) AS \"dcrPts\", SUM(CASE WHEN ssp.business_rules_applied = '000' THEN 0 ELSE 1 END) as \"businessRulesApplied\", P.JBR_STD_PKG AS \"stdPack\", P.AVG_AGE AS \"avgAge\", P.GROUP_CODE as \"groupCode\", P.NATIONAL_VIO AS \"nationalVIO\", "