How many FKs is too many ?

Hi Oracle gurus,

I have two tables, one with 100.000 rows and the other with about 4 million rows. Each table has about 55 columns, with 15 of them refer to a reference Table.

If I put FK constraint on these 15 columns (mean I have 15 FKs). Is this too many ? will this cause poor performance ? Is there any best practices for this ?

Thank you for your help,
xtanto Received on Thu Oct 21 2004 - 06:37:03 CDT