Re: Impact of foreign key on insert or update to Parent table

mavic.sood_at_gmail.com wrote:
> In case of a Foreign key constraint on the child table in a parent and
> child relationship, how does the Foreign key contraint impact the
> performance of any massive Insert or Update on the PARENT table?
> The specific scenario does not update the primary key of the parent
> table. This parent table primary key is the one that is used by the
> child table to define the foreign key.
>
> Would we see better performance for Insert or Update of records in
> PARENT table if we disabled the constraint on the child table?
>
> Thanks
>

What relation has the parent table to the child? None - hence no impact.

As for your suggestion - why not test it?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...