Re: is Oracle really planning to desupport RBO?

2002-03-21 Thread Jonathan Lewis


Is that the one that comes out the Thursday
after Oracle 10i, or the Friday ?

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 19 March 2002 16:27


|Confidential sources have revealed me that Oracle will stop
supporting RBO
|as
|of Oracle 18i.
|



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: is Oracle really planning to desupport RBO?

2002-03-19 Thread Karniotis, Stephen

In reality they cannot.  Because the internal optimizer uses Rule
occasionally, they must either remove this code from the kernel or perform a
complete rewrite.

In addition, Oracle, and its VARs, have several thousand tools that utilize
rule based, for cost based is not as stable.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Monday, March 18, 2002 9:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: is Oracle really planning to desupport RBO?

They have been saying that for years.  First they must rewrite their 
own system.

-Original Message-
Bill
Sent: Monday, March 18, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L


Has anyone heard anthing official or semi-official on this?



Bill Magaliff
Framework, Inc.
914-631-2322

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: is Oracle really planning to desupport RBO?

2002-03-19 Thread Gogala, Mladen

Confidential sources have revealed me that Oracle will stop supporting RBO
as
of Oracle 18i.

 -Original Message-
 From: Karniotis, Stephen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 19, 2002 9:03 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: is Oracle really planning to desupport RBO?
 
 
 In reality they cannot.  Because the internal optimizer uses Rule
 occasionally, they must either remove this code from the 
 kernel or perform a
 complete rewrite.
 
 In addition, Oracle, and its VARs, have several thousand 
 tools that utilize
 rule based, for cost based is not as stable.
 
 Thank You
 
 Stephen P. Karniotis
 Technical Alliance Manager
 Compuware Corporation
 Direct:   (248) 865-4350
 Mobile:   (248) 408-2918
 Email:[EMAIL PROTECTED]
 Web:  www.compuware.com
 
  -Original Message-
 Sent: Monday, March 18, 2002 9:33 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: is Oracle really planning to desupport RBO?
 
 They have been saying that for years.  First they must rewrite their 
 own system.
 
 -Original Message-
 Bill
 Sent: Monday, March 18, 2002 11:23 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Has anyone heard anthing official or semi-official on this?
 
 
 
 Bill Magaliff
 Framework, Inc.
 914-631-2322
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Magaliff, Bill
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Kimberly Smith
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 The contents of this e-mail are intended for the named 
 addressee only. It
 contains information that may be confidential. Unless you are 
 the named
 addressee or an authorized designee, you may not copy or use 
 it, or disclose
 it to anyone else. If you received it in error please notify 
 us immediately
 and then destroy it. 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Karniotis, Stephen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: is Oracle really planning to desupport RBO?

2002-03-19 Thread Mogens Nørgaard

This is true for all new features from 7.1 and onwards. Apps 11i has 
been CBO'ed, so when recursive SQL statements are also CBO'ed I would 
assume there's only the rest of the world and their applications to 
worry about ;-).

Mogens

Boivin, Patrice J wrote:

All I know is that the RBO doesn't take advantage of new features as they
are added in newer versions.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent:  Monday, March 18, 2002 3:23 PM
To:Multiple recipients of list ORACLE-L
Subject:   is Oracle really planning to desupport RBO?

Has anyone heard anthing official or semi-official on this?



Bill Magaliff
Framework, Inc.
914-631-2322



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: is Oracle really planning to desupport RBO?

2002-03-19 Thread Khedr, Waleed

I have not heard Oracle is planning to desupport Oracle!

-Original Message-
Sent: Monday, March 18, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L


Has anyone heard anthing official or semi-official on this?



Bill Magaliff
Framework, Inc.
914-631-2322

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: is Oracle really planning to desupport RBO?

2002-03-18 Thread Boivin, Patrice J

All I know is that the RBO doesn't take advantage of new features as they
are added in newer versions.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent:   Monday, March 18, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L
Subject:is Oracle really planning to desupport RBO?

Has anyone heard anthing official or semi-official on this?



Bill Magaliff
Framework, Inc.
914-631-2322

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: is Oracle really planning to desupport RBO?

2002-03-18 Thread Kimberly Smith

They have been saying that for years.  First they must rewrite their 
own system.

-Original Message-
Bill
Sent: Monday, March 18, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L


Has anyone heard anthing official or semi-official on this?



Bill Magaliff
Framework, Inc.
914-631-2322

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).