Hibernate and Oracle optimizer

tads · **Posted:** Mon Mar 22, 2004 4:08 pm

Hi all,

Somebody know how to set the Oracle optimizer in Hibernate?

thanks!

[]

baliukas · **Posted:** Mon Mar 22, 2004 4:55 pm

Is it some special oracle optimizer for hibernate ?

gavin · **Posted:** Mon Mar 22, 2004 10:22 pm

You mean you would like to add a query hint to choose between the rule-based and cost-based optimizers? Or what?

We do not currently support query hints in HQL, but I am currently thinking hard about this issue.

baliukas · **Posted:** Tue Mar 23, 2004 2:18 am

Query plan trace is a usefull feature too, it can help to validate and to explain named queries without application code. I found it as a very good way for performance tuning.