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

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 26 Jun 2002 00:59:35 +1000
Message-ID: <3d1886c9$0$28004$afc38c87@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!

Mind you, drove me nuts. It's a known problem in V7, reported in Metaclick and never acknowledged by Oracle. Obviously still there in 8.0.6.

If you INSERT ... SELECT ... FROM <view>, in some cases it slows down dramatically after the first 10 or so rows. If you add the FIRST_ROWS or ALL_ROWS hints to the SELECT statement, then all is hunky-dory. Pisses me orf to be hit again in 8.0......

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam

Received on Tue Jun 25 2002 - 09:59:35 CDT