Hi, I am using Hibernate 2.1.7 and I noticed a weird behavior. I query a database using sess.createQuery(hql).setLong(0, parameter).list() and it is taking a long time, then I replaced it for sess.find(hql, new Object[] {parameter}, new Type[] {Hibernate.Long}) and it still took a long time. When I created I a hard coded string (hql) with the parameters and called sess.find(hql) the result was extremely fast, something like 100 times faster! Does anyone have an explanation for this?

Thanks in advance.

You could set showSQL=true in your Hibernate.cfg.xml file, or the following in your log4j.properties file:
log4j.logger.org.hibernate.SQL=debug
log4j.logger.org.hibernate.type=debug

I prefer the later, since showSQL doesn't show the values for prepared statements.

This will show you the SQL that is being run and what values are being returned.

Once you have the SQL you can see the plan with an apporpiate tool.
I know early versions of Oracle (8i and earlier) executed queries with schewed data faster if it was hard coded rather than as a pararmeter, eg, archive character or either 'Y' / 'N' and there were many 'Y' and few 'N' as a paramemeter it would give equal weighting so a full scan would be performed but as a hard coded value it was able to view the stats and see 'N' was minimal so it used an index.