I'm using Hibernate 3.2 and MySQL5.0 and need to use the 'IGNORE INDEX (indexName)' syntax because MySQL's query optimizer is choosing the wrong index for a number of queries.

I have tried to use Hibernate's Dialect.registerKeyword and registerFunction methods to enable this, but I haven't had any luck.

I keep getting 'unexpected token: IGNORE near line 1, column 57' errors.

Is there any way to make use of the IGNORE INDEX syntax through Hibernate? Or am I stuck?

Thanks,

Rick

I believe that you have to use SQL (not HQL) for that type of problem (index hints). That's what we are doing, at least, because I was unable to find a way to do it through HQL.