Hi.

I am using xdoclet to create mapping files for schema export. I have a parent persistent object containing a Set of children.

I also have a complex SQL query executed through JDBC to query the table created via the Set xdoclet.

I wish to have an index on one of the columns purely for the JDBC SQL query, but I want to keep the children housed in a Set within my object

Does anyone know how I can create an index on a column using xdoclet independently of the Set xdoclet?

Thanks.

Hibernate version: 2.1

Name and version of the database you are using: postgres 7.4