Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5 Optimiser
canningt_at_my-deja.com wrote:
>
> I have recently upgraded from V7.3.4 on my test &
> production box to V8.0.5. In doing so have
> noticed diferences in the execution plan of the
> optimiser ie in production a simple 3 table query
> performs full table scans whereas on test it uses
> indexes. 3 tables have been identically created
> on test and production with the same indexes and
> foriegn keys and stats have been computed on
> indexes and tables on both machines and tables
> contain the same number of rows but the execution
> plans are different. Anybody have any ideas?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
You're experiencing the "improvements" that come with each new version of the optimizer...
Seriously though, maybe take a look at the various v$parms that start with optimzer - some of these allow you make some nice tweaks to the 8 optimizer that were not available with 7.
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Thu Nov 25 1999 - 03:49:49 CST