Hibernate Community • View topic - How do I force Hibernate to use a particular table index?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How do I force Hibernate to use a particular table index?

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

dhutchin

Post subject: How do I force Hibernate to use a particular table index?

Posted: Tue Jan 23, 2007 4:08 pm

Newbie

Joined: Tue Jan 23, 2007 3:05 pm
Posts: 1

MySQL 4.x is choosing the wrong index for a particular query. I can use "USE INDEX(`foo-index`)" if I'm using raw SQL, but I'd rather not use raw SQL unless absolutely necessary.

Is there a way I can force the use of a particular index in, say, a Criteria Query? Forgive me if this has been asked a zillion times - I have been searching for ten minutes with no luck.

Cheers,
dhutchin

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum