Re: SQL: different execution plans at different times

From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
To: nirmalya@xxxxxxx
Date: Wed, 01 Nov 2006 14:22:05 -0800

Did you disable the automatic statistics gathering job in 10g? Can you verify
that there are no histograms on any of the predicate columns. I know, you quote
your stats gathering job as using " method_opt=>'for all columns size 1' " but
double-check anyways.
Is any of the tables by any change partitioned on any of the predicate columns?
CNY# would be the most likely candidate. I hope no one would partition on status
or visible.

Quoting Nirmalya Das <nirmalya@xxxxxxx>:



-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: SQL: different execution plans at different times
From: Nirmalya Das

References:
- SQL: different execution plans at different times
  - From: Nirmalya Das

Re: SQL: different execution plans at different times

Other related posts: