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

Friday, 18 May 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#...

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