Re: How to disable foreign key constraints in a stored procedure?

On Fri, 17 Mar 2006 17:40:58 +0000, Jeremy wrote:

> Suppose you want to bulk load data into database - the data is coming
> from a source where its integrity is guaranteed (because of the
> constaints there) and you want the quickest load time (perhaps this is a
> data migration exercise?) - is it not reasonable to want to temporarily
> disable constraints? Assuming that this is dedicated access for the
> duration?

In the data warehouse situation, it is unreasonable to even have the constraints in place. You should drop them and not disable them.

-- 
http://www.mgogala.com