Re: this 8.0.6 is gonna be the death of me!!!!

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3d1886c9$0$28004$afc38c87_at_news.optusnet.com.au...
> In article <3d183d6f$0$8508$ed9e5944_at_reading.news.pipex.net>, you said
> (and I quote):
> >
> > No worries. What gets me is when you type something like
> >
> > 13 SELECT /*+ FIRST ROWS */
> >
> > bah!
>
> Huh? I didn't type that, did I? It HAD a "_" in my system!
>

No you didn't *I* do.

or select /*+ indx (foo bar) */

or slect * from v$session;

or well you get the drift.

The rule is "if the cost based optimiser is not using your hint, Niall typed it".

--
Niall Litchfield
Oracle DBA
Audit Commission UK