A couple more notes on Firebird: If you want SELECT_MAX_TX to work like the Oracle version (i.e. operating on a union derived from JMS_MESSAGES and JMS_TRANSACTIONS) you can define the union as a VIEW, and then have SELECT_MAX_TX select from that VIEW.
The JMS_MESSAGES_DESTINATION index is likely to have exceptionally poor http://www.firebirdfaq.org/faq167/ in many use cases. Since index selectivity can have a significant impact on Firebird performance, you might consider dropping it. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4091139#4091139 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4091139 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
