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?
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 Received on Thu Mar 03 2005 - 15:59:39 CST