Re: Table access slow (solved)

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 11 Feb 2004 20:53:48 +0100
Message-ID: <f12l209ep8m01qoq96th7ask7pj25l9red@4ax.com>

On 11 Feb 2004 03:33:50 -0800, homer_at_vodafone.es (Felipe Mart?nez) wrote:

>Finally, it seems it was a CBO matter.
> I deleted statistics for all the tables and indexes envolved in
>the problem query and report came out in just 1:40 minutes. Things are
>normal now.... buf!
>
> Thanks a million, Frank!
> If you ever come to Galicia mail me and you'll get drinks and
>shellfish for free.

Bummer,
'solving' a problem by downgrading to RBO.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Feb 11 2004 - 13:53:48 CST