title: My query takes too much time in hibernate with index
body: <p>I'm using Hibernate and I have this table:</p>
  
  <p><strong>Table my_entity:</strong></p>
  
  <pre><code>ID_ENTITY        int(10) unsigned PK
  ID_ENTITY_TYPE   int(10) unsigned
  NAME             varchar(256)
  SYNONYM          varchar(32)
  KEY `INDEX_synonym` (`SYNONYM`)
  </code></pre>
  
  <p>I have got 180.000 rows in this table.</p>
  
  <p>When I execute a query, it takes quite a few seconds.</p>
  
  <pre><code> query = session.createQuery("from Entity c Where synonym = :synonym");
   query.setParameter(":synonym", MYKEY);     
   lst = query.list();  
  </code></pre>
  
  <p>How can I instruct Hibernate to use the index?</p>