I have heard from Oracle that you should stop using RULE hints as the Rule-based optimizer (RBO) will eventually be retired or totally unsupported.
We are moving away from analyze as well and using dbms_stats instead because analyze is also going away. Migrating to dbms_stats is a first step for us to shift from RULE hints to the CBO. So maybe the message "Stop using hints" only applies to particular types of hints like RULE hints. Gerardo -----Original Message----- Sent: Friday, March 07, 2003 10:44 AM To: Multiple recipients of list ORACLE-L There's always the possibility of a gap between what was said and what was heard. In my seminar, I tell people about hints, and mention a useful ones - and then say they should avoid using them if possible. Perhaps the quoted instructor said something more like "you shouldn't use hints in 9i if you can avoid it" meaning "you usually don't need to use hints, and they should be the method of last resort". It is certainly a good idea to use the UNNEST hint from time to time in 9i. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) ____UK_______March 19th ____UK_______April 8th ____UK_______April 22nd ____USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: 07 March 2003 17:01 This is facinating, where does this come from? This is the second time in a week that I've heard this statement being made by someone. Hints will never go away IMHO, and Oracle continues to add more and more of them. I was told by someone at a client site that they were told by an Oracle instructor that they should not use hints in 9i.... RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Molina, Gerardo 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).
