Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!newsfeed.cwix.com!newsfeed.icl.net!newsfeed.fjserv.net!news-lond.gip.net!news.gsl.net!gip.net!kibo.news.demon.net!news.demon.co.uk!demon!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: are hints still necessary in 9i? Date: Fri, 10 Oct 2003 08:43:48 +0100 Lines: 76 Message-ID: References: <1efdad5b.0310080503.12cd6fc8@posting.google.com> <7b0834a8.0310090729.4385b90@posting.google.com> NNTP-Posting-Host: jlcomp.demon.co.uk X-Trace: news.demon.co.uk 1065772336 16780 158.152.75.41 (10 Oct 2003 07:52:16 GMT) X-Complaints-To: abuse@demon.net NNTP-Posting-Date: Fri, 10 Oct 2003 07:52:16 +0000 (UTC) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Priority: 3 X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MSMail-Priority: Normal Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:244974 I have to disagree with your closing point. The best time to start asking about the cost of a new feature is exactly the moment when some starts proposing it as the fix to every problem (which is rather implied by your earlier comment). In passing, I've been impressed with what the tuning package can do - though I still have a lot more tests to give it, so I'm not knocking the idea, just being my usual cautious self about making sure that it is applied in the right place at the right time. -- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html ____Iceland__November (tbc) ____Belgium__November (EOUG event) ____UK_______December (UKOUG conference) Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____USA__October ____UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Venkat" <0002_eveev@oohay.moc> wrote in message news:f6nhb.26$ml5.131@news.oracle.com... > > > >And what is the cost of enabling a few profiles > >for a few special SQL statements when 99% > >of your code does not need profiles ? > >The second question is more important than the > >first - there is always a cost/benefit trade in a > >feature like this. > > > > Thats exactly true. But, its a bit too early to start making about the > cost of enabling new 10g features isn't it? > > > -V > > > > >>modifying the actual SQL statement. Simply, starting from 10g, I see > >>no future for any type of hints - no matter whether they are the > >>"good" ones, or the "bad" ones or the "ugly". > >> > >>Thanks, > >>-V > >> >