1

I would like to create only one index or composite index for multiple columns of a collection on xml file. Is there a proper way to do it? I couldnt find anything relevant. I see that it is possible on sql.

Here is my example;

<set name="properties" fetch="join" lazy="false" table="PLN_DEMAND_ORDER_ITM_PROPERTY">
    <key>
        <column name="ORDER_ID" index="IDX_PLN_DOIP_ORDER_ID"/> <=
        <column name="LINE_NO" index="IDX_PLN_DOIP_ORDER_ID"/>  <= for both column only one index is needed
    </key>
          .
          .
          .
</set>
vantilator
  • 11
  • 2

1 Answers1

0
Multiple columns can be grouped by simply **specifying the same index name** into the same index as you have clearly done it.

This link can give you better understanding. hope this helps..

Community
  • 1
  • 1
sTg
  • 4,313
  • 16
  • 68
  • 115