"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#4104961 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4104961 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
