Re: rowid vs pk delete speed

On Thu, 4 Mar 1999 23:05:50 +0000, Steve Haynes <steve_at_rwx777.demon.co.uk> wrote:

>Hi All,
>I recently experienced lousy delete performance
>when doing PLSQL array deletes by rowid.
>To my amazement, I found that using a six column
>primary key to do the deletes was about twice
>as fast as using rowid.
>This was on 8.0.5 on NT.
>Thoughts?

Maybe it's because the primary key index must be updated to reflect the deletion. When deleting by primary key, the appropriate index blocks are examined on the way to deleting the row whereas when deleting by rowid, the database block must be first be examined to get the key values to update the index. Received on Sat Mar 06 1999 - 11:01:53 CST