Re: Oracle 8.0.5 Optimiser

Hi

How did you analyze those tables in your production? try drop the statistics and reanalyze them with the following

analyze table ... compute/estimate for table for all indexes. after reanalyzing them
do select * from dba_histgram where table_name=yourtable. make sure not rows found.

then try your select stmt against those three tables. Any difference with your plan?

Please drop me a line, you it works for you.

Good luck.

canningt_at_my-deja.com wrote:
>
> I have recently upgraded from V7.3.4 on my test &u
> 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 - 15:37:20 CST