Re: Where does GC grab historical SQL plans from?

Do you need the histograms? Why not just not collect them.

On 2011-05-13, at 9:22 AM, Rich Jesse wrote:

> Because we have histograms, CBO sees this and
> correctly chooses another index for that query.  And because we're on 10.1,
> if this should be the first hard parse of that SQL, the "incorrect" index
> sticks for subsequent runs. 

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

Other related posts: