On Wed, 2006-03-29 at 11:35, Nico Callewaert wrote:
> Hi !,
>
> Is it wise to define foreign keys for referential entegrity ?
> Example : I have a customer table with 40 fields. Out of that 40
> fields, 10 fields contain information linked to other tables. So, is
> defining foreign keys for th
On Wed, 29 Mar 2006, Nico Callewaert wrote:
> Is it wise to define foreign keys for referential entegrity ?
> Example : I have a customer table with 40 fields. Out of that 40
> fields, 10 fields contain information linked to other tables. So, is
> defining foreign keys for these 10 fiel
On Mar 29, 2006, at 12:35 PM, Nico Callewaert wrote:
Because from what I understand, for every foreign key, there is an
index defined. So, all these indexes has to be maintained. Is
that killing performance ? What's the best practise : defining
foreign keys or not ?
If your applicatio
Hi !, Is it wise to define foreign keys for referential entegrity ? Example : I have a customer table with 40 fields. Out of that 40 fields, 10 fields contain information linked to other tables. So, is defining foreign keys for these 10 fields a good idea ? Because from what I understand,