Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: are hints still necessary in 9i?
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.htmlReceived on Thu Oct 09 2003 - 15:01:46 CDT
>
> 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
>
>