We shant tell your bride how you whiled away the
hours on your wedding day. ;)

Jared

On Saturday 08 March 2003 17:53, Connor McDonald wrote:
> Just to add my meaningless diatribe to the discussion,> I think that there are "good" hints and "bad" hints.>> For example, first_rows(n) is a good hint, in that you> are giving the optimizer more information as to what> your motivations are for this query, without stifling> it into a choice that may not be appropriate down the> track.>> Hints such as index(tab,idx) are "bad" hints, because> you are more exposed to grief. If the index is> renamed, then its no longer a hint. If the data> distribution changes, or the index is rebuilt in> reverse or compressed, then it may no longer be a good> option, etc.>> In terms of the vendor speak of "hints imply weak> optimizer" I think thats nonsense. Having worked with> DB2 in the past, nothing used to be more irritating> then coming up with bizarre convolutions on an> otherwise simple SQL to ensure that certain indexes> were or were not chosen.>> Cheers> Connor>> PS - Its probably a little sad that I'm chit-chatting> on hints on the morning of my wedding day, but hey,> you gotta pass the time somehow whilst the other half> is getting the hair and makeup done :-)>>>> --- "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> wrote: >> It's like the Auto-pilot>> > -----Original Message-----> > To: Multiple recipients of list ORACLE-L> > Sent: 3/8/03 2:13 PM> >> > Stephane> > I don't see how Oracle could ever have an> > official position on hints.> > If> > they say hints are going away, many developers> > panic. If they say hints> > are> > great, then Oracle competitors will claim Oracle has> > a bad optimizer.> > A key political issue in some shops is "Using> > hints makes our code> > Oracle-specific". My reply is that hints are only> > comments that another> > database will ignore.> >> > Dennis Williams> > DBA, 40%OCP, 100% DBA> > Lifetouch, Inc.> > dwilliams_at_lifetouch.com> >> >> > -----Original Message-----> > Sent: Friday, March 07, 2003 12:19 PM> > To: Multiple recipients of list ORACLE-L> >> >> > Hi,> >> > I have to write a SQL and PL/SQL guide for our> > developpers.> > Some are good but most of them can use help.> >> > I'm not a big fan of hints except for insert append,> > I used them only if> > I> > really need to.> >> > In last october I went to a 3 days DB2 UDB course,> > unless I miss> > something> > there are no hint with DB2 UDB.> > So I was thinking that when the Oracle optimiser> > would be more mature> > maybe> > hints would go away.> >> > I just want to know what is Oracle direction with> > hints.> >> > TIA> >> > Stephane> >> >> > -----Original Message-----> > Robert - IL> > Sent: Friday, March 07, 2003 12:01 PM> > To: Multiple recipients of list ORACLE-L> >> >> > 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> >> > -----Original Message-----> > To: Multiple recipients of list ORACLE-L> > Sent: 3/7/2003 10:04 AM> >> > Hi,> >> > Does Oracle have an official position on hints ?> > Will they go away as the optimiser is becoming> > bettre or they are there> > to stay ?> >> > TIA> >> >> >> > Stephane Paquette> >> >> > Administrateur de bases de donnees> >> > Database Administrator> >> > Standard Life> >> > www.standardlife.ca> >> > Tel. (514) 925-7187> >> > stephane.paquette_at_standardlife.ca> > <mailto:stephane.paquette_at_standardlife.ca>> >> >> > --> > Please see the official ORACLE-L FAQ:> > http://www.orafaq.net> > --> > Author: Freeman Robert - IL> > INET: FREEMANR_at_tusc.com> >> > 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: ListGuru_at_fatcity.com (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: Stephane Paquette> > INET: stephane.paquette_at_standardlife.ca> >> > 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: ListGuru_at_fatcity.com (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: DENNIS WILLIAMS> > INET: DWILLIAMS_at_LIFETOUCH.COM> >> > 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: ListGuru_at_fatcity.com (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: Khedr, Waleed> > INET: Waleed.Khedr_at_FMR.COM> >> > 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: ListGuru_at_fatcity.com (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).>> =====> Connor McDonald> web: http://www.oracledba.co.uk> web: http://www.oaktable.net> email: connor_mcdonald_at_yahoo.com>> "GIVE a man a fish and he will eat for a day. But TEACH him how to
fish,
> and...he will sit in a boat and drink beer all day">> __________________________________________________> Do You Yahoo!?> Everything you'll ever need on one web page> from News and Sport to Email and Music Charts> http://uk.my.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: jkstill_at_cybcon.com
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: ListGuru_at_fatcity.com (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: Freeman Robert - IL
INET: FREEMANR_at_tusc.com
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: ListGuru_at_fatcity.com (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).