Re: Why forwarding pointers?

"Richard Foote" <richard.foote_at_bigpond.com> wrote:
> Hi Xho,
>
> This is a no win situation and Oracle has chosen the path of low
> performance hit now as it might not be an issue in the future or it could
> be fixed at a more appropriate time.
>
> When the update transaction causes a row to migrate there is already a
> performance hit as Oracle needs to find another block to house the row
> and apply all the necessary changes. To add all the necessary index
> maintenance tasks as well could potentially impact such transactions to
> an unacceptable level.

Thanks, Richard. So it's mostly just the straightforward trade-off, not some subtler issues that I was overlooking.

> However to say we have this "redirection hit forever" is not correct. If
> we detect this is an issue, we can rectify the problem at an appropriate
> time when normal processing is not impacted.

Well, you can rectify the problem. I'm not quite so talented yet. :)

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
                    Usenet Newsgroup Service