Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.0.5 Optimiser
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.
Received on Thu Nov 25 1999 - 10:52:26 CST