Re: How many FKs is too many ?

xtanto wrote:

> 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

The numbers, in and of themselves are not a problem. But a table with 55 columns is suspect. And a table that has 15 referential constraints highly suspicious. I'd take an hour or two and re-examine the design based on a concept called normalization.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)