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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 25 Jun 2002 10:52:46 +0100
Message-ID: <3d183d6f$0$8508$ed9e5944@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 - 04:52:46 CDT