Re: Why forwarding pointers?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 3 Oct 2002 20:44:18 GMT
Message-ID: <3D9CAC22.38B37ADF@peasland.com>

The biggest reason is that database systems tend to work on the principle that they do the least amount of work as possible. This cuts down on overhead so that transactions can get as much processing as possible. If a row gets migrated, then think of all the things that have to happen if there is no forwarding pointer....

HTH,
Brian

ctcgag_at_hotmail.com wrote:
>
> When a row is migrated, Oracle leaves a forwarding pointer.
>
> Is this solely a matter of performance, that they would rather take
> the redirection hit forever rather than take the onetime hit of tracing
> down all the indices and changing them? Or is it not convenient/possible
> to maintain ACID conditions without forwarding pointers, for some reason I
> don't quite grasp?
>
> Thanks
>
> Xho
>
> --
> -------------------- http://NewsReader.Com/ --------------------
> Usenet Newsgroup Service
Received on Thu Oct 03 2002 - 15:44:18 CDT