SchemaExport does not propagate parent indexes to <union-subclass> tables ------------------------------------------------------------------------- Key: HHH-884 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-884 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.0.3 Reporter: Keith D Gregory Assignee: Gavin King Fix For: 3.1 rc 1 Attachments: Cat.hbm.xml, Cat.java, PolydactylCat.hbm.xml, PolydactylCat.java, propagateConstraints.diff, propagateIndexesToUnionSubclasses.diff, Test.java When using <union-subclass>, you want to propagate parent table indexes to child tables to improve query speeds. For example, this HBM (a cut-n-paste of the separate files I'm attaching, so may have errors) should index cats by name in both the CAT and POLYDACTYL_CAT tables. <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="example.Cat" table="CAT"> <id name="id" type="string" unsaved-value="null" > <column name="CAT_ID" sql-type="char(32)" not-null="true"/> <generator class="uuid.hex"/> </id> <!-- index this so we can look for cats by name --> <property name="name"> <column name="NAME" length="16" not-null="true" index="IDX_NAME"/> </property> <union-subclass name="example.PolydactylCat" table="POLYDACTYL_CAT"> <property name="leftFront"/> <property name="rightFront"/> <property name="leftRear"/> <property name="rightRear"/> </union-subclass> </class> </hibernate-mapping> However, with versions up to 3.0.3, this only creates the index on the CAT table.