Hi,
I'm developing an application using hibernate with oracle. To improve the performance in one process I need create an index for a key in one map.
That is the declaration of my map, I use attribute foreign-key:
Code:
<class name="HistoricoConsumoHorario" table="h_consumohorario"
lazy="true">
<id name="id" type="long" unsaved-value="null">
<generator class="native" />
</id>
<map name="valores" table="h_consumohorario_det" sort="natural"
cascade="all">
<key column="idHistorico" foreign-key="FK_HCH" />
<index column="fecha"
type="com.aia.utils.datetime.DateTimeUserType" />
<one-to-many class="ConsumoHorario" />
</map>
</class>
and oracle create a foreign key for column
idHistorico but not the index. How can I do to create automatically an index?
Thanks in advance,