Not anymore I'm not :( Have I been looking at this backwards?
I was looking at what the table being deleted from REFERENCES,but its what is REFERENCing that table I should be looking at, isn't? :(
On Sun, 10 Oct 2004, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:I posted to -sql the other day about an atrociously slow DELETE on a table that has two FKs to a 'parent' table ... if the # of records in the table that match the condition is 1, its fast ... in the sample I'm working with, there are 1639 records in the table ...
"parent" table? A DELETE doesn't check FKs in the table it's deleting. What it checks are FKs in other tables that reference items in the deletion table. You sure you are worrying about the right set of FKs?
regards, tom lane
---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
