How to index a field using H3 annotations?

Michael Baranov · **Joined:** Fri Apr 22, 2005 3:39 pm **Posts:** 18

Greetings!

This Q is probably lame... maybe not. I can't find the workaround nanywhere:

Does anybody know how to make a column (field) indexed using Hibernate3 annotations? Is there a way at all? Ex:

@Entity
class MyEntity
{
private long id;
private String name;

@Id
// id getter/setter ...

@Basic // <- I want this field to be indexed. ShemaExport generates no index for it by default.
// name getter/setter...
}

Do you set indexes on all field you use in your "where..." queries?
Thanks!

emmanuel · **Posted:** Mon May 09, 2005 5:01 am

This is not possible right now, vote for it in JIRA.
We do not add an index on proeprties involved in where clauses, it would be very dangerous to do so.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

it is table characteristic, not property - it need be on class level , if you add it
reason is simple - index can have more properties/columns

It is similar for PK, but it is in ejb3 (for me wrong place)

regards

emmanuel · **Posted:** Fri May 13, 2005 4:13 am

emmanuel wrote:

We do not add an index on proeprties involved in where clauses, it would be very dangerous to do so.

I mean out of the box :-)