hibernate auto generate database indexes

[Alexander Curvais]

Hi,

i use

   @Index(columnNames="date", name="idx_date") 

dunno why because does it do anything?

i would like it if it would generate the index in the database are there any tweaks or easy ways to have hibernate generate indexes i specify?


regards Alexander

[Kadle Rajesh]

I think we can use "index" attribute in column mapping like below, to create index:

<column name="date" index="idx_date"/>

This will be created when we run hbm2ddl tool.

[Cameron Wallace McKenzie]

Make sure you're using the proper package for the @Index annotation. The same annotation is defined in several libraries, which can cause issues.

-Cameron McKenzie