Re: Guidelines for avoid Bind Variable Peeking behavior
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: roberto_veiga@xxxxxxxxx
- Date: Sun, 31 May 2009 08:32:53 -0600
What Oracle version?
I am curious to know more how the situation became worse without
histograms. The plans shouldn't change as often without histograms.
What is wrong with access plans using hash joins? I often prefer
those over nested loops.
At 08:14 AM 5/31/2009, Roberto Veiga wrote:
We have already tried to remove histograms and the situation become worse.
-Access plan using Hash Join
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
