not clever just the result of been terminally unable to type myself.
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:4UXR8.20588$Hj3.65323_at_newsfeeds.bigpond.com...
> 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 - 06:36:55 CDT
