Hello,

There's a very old issue related to indexes that are not automatically generated for foreign key columns in Oracle, whereas most of the time it is advised to add indexes to FK in an Oracle Db (related to table locks and performance issues)

here : viewtopic.php?t=948998
and here : viewtopic.php?t=924910

AFAIKT the probleme is still there, so I wanted to created my own Oracle dialect to both generate the FKs and the indexes.

I've tried to override the getAddForeignKeyConstraintString of the dialect, but the method expects the "alter table" part of que foreign key creation, and for oracle I'm not able to create an index with an alter table. Anyway, I need to commands : an "alter table" for the FK creation, and a "create index" for the index creation.

Is there an advanced way to modify a dialect an be able to execute two commands for one FK ?

Thanks.