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

[genman]

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