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