"Jeremy Stone" wrote : | | CREATE_IDX_MESSAGE_REF_TX=CREATE INDEX JBM_MSG_REF_TX ON JBM_MSG_REF (TRANSACTION_ID, STATE) | | | | Not sure yet if this will have any undesired side effects or whether the same change should be applied for other database persistence serices. | | Any thoughts? Instead of adding the state column to the JBM_MSG_REF_TX index, does it also solve your problem by adding a new index solely on the state column. e.g. CREATE INDEX TEST_INDEX_STATE ON JBM_MSG_REF(STATE). ? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4104961#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...