Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: are hints still necessary in 9i?

Re: are hints still necessary in 9i?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 9 Oct 2003 21:01:46 +0100
Message-ID: <bm4eqc$pk4$1$8300dec7@news.demon.co.uk>

But how are Profiles different from Outlines ?

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.

--
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


>
> Forgive me for not exactly sticking with the subject that goes "are
hint
> necessary in *9i*". In 10g, we have "SQL Profiles" which exactly is
a
> set of such information which Tom calls "good hints", that guides
the
> optimizer to do the right thing rather than forcing the optimizer to
> make a particular decision. Even better, one can create SQL Profiles
for
> any SQL, no matter they are from packaged apps or custom apps
without
> 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
>
>
Received on Thu Oct 09 2003 - 15:01:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US