Hi,
I am facing a problem with using the indexes created on my database through a hibernate Query by Example.
Here are the details-
TABLE- PERSON
=============
Name Address City Country

The index is on Name column. Now when i use the Example object and query this table the hibernate generated query always reads- where CITY=... and NAME = ...
Because of this ordering of the where clause, the index is not used.

Is there any way by which i can control the order in which the column names appear in the where clause?