Re: Query takes too long to execute

From: <mylesv_at_gmail.com>
Date: 16 Nov 2006 05:36:34 -0800
Message-ID: <1163684194.595546.318140@b28g2000cwb.googlegroups.com>

sybrandb wrote:
> Did you change optimizer_index_cost_adj from its default 100 to 40?
> Did you change optimizer_index_caching from 0 to 90?
> Or did you calculate system stats using dbms_stats.gather_system_stats.
> This behavior is quite common for non-driving tables with default
> values for those parameters.
> As the value of the key can't be gathered from the statement, default
> cardinality is assumed.
>
> Hth
> --
> Sybrand Bakker
> Senior Oracle DBA

They're at 100 and 0, respectively. I'll try the values you suggested.

I did an "estimate statistics" with 33% sample size on all tables and indexes a few days ago.

Thanks!
Myles Received on Thu Nov 16 2006 - 07:36:34 CST