Let me elaborate it. Foreign key is used to check the referencial integrity. It is to confirm the data you entered is indeed match the rule with the parent tables. So, Oracle does not create any index for foreign key specified. That is, no storage created for foreign key generation.


Susan