Re: Q: Indexes & Rule based Optimizer

On 17 Apr 2001 19:26:18 +0100 (BST), Andrew Mobbs <andrewm_at_chiark.greenend.org.uk> wrote:

>Sybrand Bakker <postbus_at_sybrandb.demon-verwijderdit.nl> wrote:
>>
>>
>>First of all: please stop developing applications using the RBO.
>>Development on it has stopped in 1993, and CBO has now so much more
>>functionality and better access paths, that RBO must be considered
>>inferior to CBO. Officially it has been desupported, and I just pray
>>you prepare before the day Oracle removes it. This might be never, but
>>then it might be 9i.
>
>I agree with the sentiment, but I doubt it'll be dropped for a while,
>at least until Oracle stop using it for their own applications :-)
>(Correct me if I'm wrong, but I believe that Oracle Human Resources
>still uses the RBO, amoungst others).

I only made the remark because I am very much aware how many sites ignore (desupport) notices. I don't want them to be taken by surprise. Oracle finally *did* remove internal in 9i.

Regards,

Sybrand Bakker, Oracle DBA

Sybrand Bakker, Oracle DBA Received on Tue Apr 17 2001 - 15:58:06 CDT