killbill-memoizeit

Add FORCE index for notificationQ

6/27/2012 2:52:50 PM

stephane brossier

Commit: d80a89c

Tree: ce160dc

Parents: f707431

Changes

util/src/main/resources/com/ning/billing/util/notificationq/dao/NotificationSqlDao.sql.stg 1(+1 -0)

Details

util/src/main/resources/com/ning/billing/util/notificationq/dao/NotificationSqlDao.sql.stg 1(+1 -0)

diff --git a/util/src/main/resources/com/ning/billing/util/notificationq/dao/NotificationSqlDao.sql.stg b/util/src/main/resources/com/ning/billing/util/notificationq/dao/NotificationSqlDao.sql.stg
index 8eb289a..3c81e21 100644
--- a/util/src/main/resources/com/ning/billing/util/notificationq/dao/NotificationSqlDao.sql.stg
+++ b/util/src/main/resources/com/ning/billing/util/notificationq/dao/NotificationSqlDao.sql.stg
@@ -14,6 +14,7 @@ getReadyNotifications() ::= <<
       , processing_available_date
       , processing_state
     from notifications
+    FORCE INDEX (idx_comp_where)
     where
       effective_date \<= :now
       and queue_name = :queueName