Re: Performance problem: anything else I can do to make this faster?

sconover_at_gmail.com wrote:

> Yep, I gathered stats on the whole schema using
> dbms_stats.gather_table_stats.
>
> Does it make any sense that even just using the RBO a join of a table
> with 1m rows with a table with 2m rows would take this long? This
> doesn't seem like a big deal in terms of what Oracle can handle. Those
> 1.4m logical reads are what bother me...
>
> Are there any obvious db environment / setup / config values that could
> be off that would cause my problem?
>
> -Steve

It makes sense to not use the RBO depending on your version.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)