I'm using jboss CMP. Its creating automatically my Tables as well. Is there any option to specify some indexes constraints? perhaps using jbosscmp-jdbc.xml ? I would be very gratefull for any examples...
You can specify which fields need to be indexed (see wiki or dtd).
These are simple indexes (not compound). They are created when the table is created, or can be added later on when alter-table is used.