Posts Tagged ‘ histograms ’

Implicit Datatype Conversion + Histograms = Bad Execution Plan?

June 8, 2011
By

Earlier today I exchanged some tweets with @martinberx about some optimizer questions and after posting more information on the ORACLE-L list, I was able to reproduce what he was observing. The issue: DB: 11.2.0.2.0 – 64bit I have a small query with a little error, which causes big troubles. The relevant part of the...

Read more »

Choosing An Optimal Stats Gathering Strategy

March 26, 2008
By

Recently the Oracle Optimizer Development Team put out a White Paper entitled Upgrading from Oracle Database 9i to 10g: What to expect from the Optimizer. This paper discusses the main differences between 9i and 10g in the subject area of the Optimizer and Statistics. As G.I. Joe said, “Now we know! And knowing is...

Read more »