Well spotted (clever dick :)
Richard
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3d183d6f$0$8508$ed9e5944_at_reading.news.pipex.net...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:RCWR8.20520$Hj3.64300_at_newsfeeds.bigpond.com...
> > Hi Nuno
> >
> > That's impressive. How did you manage to run it so fast the first time
:)
> > Why Oracle moved on from 8.0.6 I'll never know ;)
>
> By remembering the hint.
>
> > Richard
> > "Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
> > > 13 SELECT /*+ FIRST_ROWS */
> <Snip>
> > > Elapsed: 00:00:16.29
> <snip>
> > > 13 SELECT
> > > 14 641797.000000000000000, OPRID,
>
> > > Bloody hell!!!!
> > > sorry folks, just had to vent...
>
> No worries. What gets me is when you type something like
>
> 13 SELECT /*+ FIRST ROWS */
>
> bah!
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
>
Received on Tue Jun 25 2002 - 05:56:42 CDT
