Hello,
I am trying to optimize a query that returns names from a table where the lastName starts with a certain letter.

Currently, I am using the following:

Criteria criteria = HibernateUtil.getSession().createCriteria(Contact.class)
.createAlias("contactInfo", "c")
.add(Expression.ilike("c.lastName", searchLetter + "%"))
.addOrder(Order.asc("c.lastName"));

return criteria.list();

which is working, but is slow. I have an index on the ContactInfo table on lastName column, which helps, but I'm hoping for better...

I am using a PostgreSQL db, for which I am fairly new at. Is there a better way?
Thanks for any Help!
Eric

I'm not sure if there's a way around your "startswith" query. What you are doing here is exactyly what anyone would do even with or w/o Hibernate.

Typically queries like these tend to be slower and you might want to look at a query plan of sorts on your SQL (not sure of Post Gre SQL supports that).