Re: DELETE w/ROWID takes 6 minutes?
From: <flatline_at_mailbox.hu>
Date: 16 Nov 2002 07:00:41 -0800
Message-ID: <bc3a43ba.0211160700.6bfd8a3e_at_posting.google.com>
Date: 16 Nov 2002 07:00:41 -0800
Message-ID: <bc3a43ba.0211160700.6bfd8a3e_at_posting.google.com>
Hi there!
Can this happen even if the original query didn't find the according ROWID? Hard to believe, since it does not have to check anything...
> This can happen if you have a big table that has a foreign key constraint
> to the table from which you are deleting the record, but no index on the
> foreign key columns. If you delete a record in the parent table, Oracle
> does a full table scan on the child table to check if the constraint is not
> violated.
>
> HTH,
> Thijs Blaauw
Received on Sat Nov 16 2002 - 16:00:41 CET