Re: Where does GC grab historical SQL plans from?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Tue, 17 May 2011 06:29:11 -0600
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
