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


Wolfgang Breitling
Centrex Consulting Corporation

Other related posts: