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 withouthistograms. The plans shouldn't change as often without histograms.What is wrong with access plans using hash joins? I often preferthose 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

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

References:

Guidelines for avoid Bind Variable Peeking behavior
From: Roberto Veiga

Other related posts:

» Guidelines for avoid Bind Variable Peeking behavior - Roberto Veiga
» Re: Guidelines for avoid Bind Variable Peeking behavior - troach
» Re: Guidelines for avoid Bind Variable Peeking behavior - Wolfgang Breitling
» Re: Guidelines for avoid Bind Variable Peeking behavior - Stephane Faroult
» Re: Guidelines for avoid Bind Variable Peeking behavior - Kerry Osborne
» Re: Guidelines for avoid Bind Variable Peeking behavior - Roberto Veiga
» Re: Guidelines for avoid Bind Variable Peeking behavior - Roberto Veiga
» RE: Guidelines for avoid Bind Variable Peeking behavior - Allen, Brandon
» Re: Guidelines for avoid Bind Variable Peeking behavior - Kerry Osborne
» Re: Guidelines for avoid Bind Variable Peeking behavior - Sherrie . Kubis
» RE: Guidelines for avoid Bind Variable Peeking behavior - Allen, Brandon
» Re: Guidelines for avoid Bind Variable Peeking behavior - Tony Adolph
» Re: Guidelines for avoid Bind Variable Peeking behavior - Kerry Osborne