join « Performance « JPA Q&A





1. Performance Problem with multiple joins    forum.hibernate.org

select a.id as id from tableA a left outer join setTableB1 stb1 on a.id=stb1.a_id left outer join tableB tb1 on tb1.b_id=tb1.id left outer join tableC tc1 on tb1.id=tc1.id left outer join setTableB2 stb2 on a.id=stb2.a_id left outer join tableB tb2 on tb2.b_id=tb2.id, left outer join tableC tc2 on tb2.id=tc2.id where tc1.attribute = "SomeValue" tc2.attribute = "SomeValue"

2. HQL performance: sleect new using joins inside    forum.hibernate.org

3. Join performance in HQL    forum.hibernate.org

Beginner Joined: Thu Apr 12, 2007 10:38 am Posts: 22 Hi I've just tried to improve performance for a select on quite a large object which has lots of links to other tables. I was originally using session.get() but I've changed it to use a HQL query with lots of "left join fetch" statements instead. I thought Hibernate would combine all ...

4. performance: ANSI vs. theta style joins    forum.hibernate.org