alter table add constraint

[ovidius]

Oracle does not automatically create indexes on foreign keys. It looks to me like this is what you are looking for. If yes, then create manually your indexes on that foreign key, and there you can state any storage option you need.