Hi,

We are using hibernate 3.1, For searching a data in the table we need to refer atleast three tables.

Which one of the following option is best
1. Using Criteria
2. Using Outer join HQL queries
3. Using Inner Join in HQL queries

Whether HQL queries minimize the performance of Hibernate or not ?


Thanks in advance.

HQL is a little more flexible than Criteria, but, ultimately, the options you give are irrelevant in relation to performance.

Your HQL using inner or outer joins should depend on the business needs of your application, rather than on performance considerations.
For example, when you need a parent present in a resultset even when there are no children, you use an outer join.

A much better way to tune the performance of your queries is to focus on their fetching strategy, both in terms of what kind of fetching you do (join, subselect) and when you do it (eager, lazy).