Re: are hints still necessary in 9i?

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_at_oohay.moc> wrote in message
news:f6nhb.26$ml5.131_at_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

> >>

>