The way I read it is that you can still use it, it's just not officially supported. i.e. If you call up Oracle Support and say my query (SELECT /*+RULE */ blah blah blah...) crashes the database, they will say "Sorry, you're out of luck" or "Switch to cost-based".
Some apps (e.g. Siebel) still rely on RULE or they go down the terlit... -----Original Message----- Sent: Tuesday, October 07, 2003 2:05 PM To: Multiple recipients of list ORACLE-L OK, dumb question. Does this mean the rule hint won't be possible? Application I support mostly uses CBO but there have been cases where we had to resort to RBO hint. 'course it'll be some time before we can consider v10... Kip |Hi Jared, |haven't seen it, too. But the fact |was spreaded over the newsgroups. |We still have some 3rd party apps that don't use |*any* feature above Oracle 7 (well, almost). Queries with |the RULE hint where it's not necessary. |But if we change a thing, support will be lost. |So we decided to rewrite the whole app. |Lucky me: enough work for the next years. |Greetings, |Guido |>>> [EMAIL PROTECTED] 07.10.2003 01.34 Uhr >>> |First time I've seen this note: 189702.1 |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Guido Konsolke | INET: [EMAIL PROTECTED] |Fat City Network Services -- 858-538-5051 http://www.fatcity.com |San Diego, California -- Mailing list and web hosting services |--------------------------------------------------------------------- |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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Cunningham, Gerald INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
