We’re rewarding the question askers & reputations are being recalculated! Read more.
1

Yes, it will definitely add overhead if you have foreign keys pointing to the table that you are trying to clear records from. This is because it needs to ensure that the constraint is not violated once the data has been removed. I've personally seen deletes take days with foreign key checks, but hours if you remove the foreign keys before performing the ...


Only top voted, non community-wiki answers of a minimum length are eligible