Does Hibernate take indexes into account?

tylerdurden83 · **Joined:** Thu May 03, 2012 4:01 pm **Posts:** 5

Hello everyone, I was wondering something I just noticed.

I have this query in hibernate:

Code:

Calendar cal = Calendar.getInstance();
cal.add(Calendar.HOUR_OF_DAY, -12);
Query q = entityManager().createQuery("SELECT COUNT(o) FROM BuyRespPraomp o where insertTimestamp > :date ", Long.class);
q.setParameter("date", cal.getTime());
return (Long) q.getSingleResult();

The field insertTimestamp is indexed on the database.
Now, what I noticed is that this query takes a couple milliseconds if I execute it from say Toad, and as much as five seconds if I run it from my application using Hibernate.
Am I being silly and missing something obvious here?

Thanks as always,
TD

Ajit Singh · **Joined:** Wed Feb 06, 2013 2:43 am **Posts:** 46

Hibernate does not take indexes unless you don't specify it.
More info : http://www.znetdevelopment.com/blogs/2009/10/07/using-use-index-with-hibernatemysql/.

And i dont think you are missing anything in your code here.