On Apr 14, 2005, at 7:59 AM, Richard van den Berg wrote:

How do I explain why test cases 2 and 3 do not come close to case 1? Am I missing something obvious?

there's cost involved with enforcing the FK: if you're indexes can't be used then you're doing a boatload of sequence scans to find and lock the referenced rows in the parent tables.

Make sure you have indexes on your FK columns (on *both* tables), and that the data type on both tables is the same.

Vivek Khera, Ph.D.
+1-301-869-4449 x806

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to