specifying the order of columns in an index in the mapping

lnz · **Joined:** Mon Sep 19, 2005 4:30 am **Posts:** 11

I know how to specify indexes (indices) on the column entries of my hibernate mapping.
I know how to let a single column take part in two different indexes.

What I don't know is how to specify the order of the columns in the index (which seems to be a common requirement to me).

In other words:
is it possible - in the following example - to let
FirstIndex be an Index on (name1, name2) and
SecondIndex be an Index on (name2, name1)?

Code:

<poperty name="name1" type="something.Class">
    <column name="NAME1" index="FirstIndex,SecondIndex"/>
</property>
<poperty name="name2" type="something.Class">
    <column name="NAME2" index="FirstIndex,SecondIndex"/>
</property>

Thanks for your Help

lnz

kgignatyev · **Posted:** Tue Sep 20, 2005 11:42 am

Why do not you generate database from a script and create those indexes as you need them to be?