I have a table with a Deleted column and a multi-field index. Unfortunately the index on the Deleted column is used instead of the multi-field index which results in unacceptable performance. Since I'm using the 'like' operator on one of the muti-field index columns in the where clause, it doesn't seem to matter how I rearrange the query. I need to use the 'use index' command in the query.

Does Hibernate support this? Is there a way to hint to the underlying database's optimizer which index to use?

Is there a workaround if not?