Subject RE: [IBO] Foreign Key
Author Nico Callewaert

I was thinking the same. For example I have a customer with COUNTRY =
10, that numeric value is referencing a record in the COUNTRY table with the
rest of the information about that country, the name and still other things.
I think I'm in the same confusion like you

Nico Callewaert

-----Oorspronkelijk bericht-----
Van: guido.klapperich@... [mailto:guido.klapperich@...]
Verzonden: dinsdag 3 april 2001 15:03
Onderwerp: Re: [IBO] Foreign Key

> No, don't define them formally as Foreign keys. You will get 6
relationships with low selectivity indexes and it will kill performance.
> Only use the FOREIGN constraint for master-detail or parent-child (tree)
relationships. Hand-code the cascade triggers for lookup relationships
such as those you mention.

Hi Helen

I thought the relationships between customers and the six tables are
master-detail relationships.


Yahoo! Groups Sponsor

Click Here to Find Software Faster

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]