Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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)Received on Thu Mar 03 2005 - 19:25:14 CST