[jboss-user] [Performance Tuning] - Re: HQL/ JPA-QL Query Tuning: How to enforce the join order

genman do-not-reply at jboss.com
Fri May 18 21:48:39 EDT 2007


Hmm... I suspect that DBs can often figure out the optimal join order, so you need to make certain you need to specify the order at all.

You can also use views to simplify joined table queries. The view itself can specify join order.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4046968#4046968

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4046968



More information about the jboss-user mailing list