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
smime.p7s
Description: S/MIME cryptographic signature