Hi,

I have to get data from the database from different tables using multiple conditions (using joins) . so i thought of using Criteria api -- DetachedCriteria, Restrictions class etc.

But i feel the hql is simpler, also supports joins and im afraid using Criteria api may degrade the performance comparitively.

Can anyone tell me which is better to use for effective performance?

Both HQL and Criteria API offer the same performance as both are executed as SQL in database side. And Hibernate use the same logic for both.

What extra benefit Criteria API offers over HQL is dynamic query building. You can think about your query in terms of Objects instead of SQL.

Here is notes from hibernate docs: