java - Is it possible to create one index for more than one column? hiberanate -

java - Is it possible to create one index for more than one column? hiberanate -

i create 1 index or composite index multiple columns of collection on xml file. there proper way it? couldnt find relevant. see possible on sql.

here 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"/> <= both column 1 index needed </key> . . . </set>

multiple columns can grouped **specifying same index name** same index have done it.

this link can give improve understanding. hope helps..

java database hibernate collections hibernate-mapping