Re: Guidelines for avoid Bind Variable Peeking behavior

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Sun, 31 May 2009 08:32:53 -0600
Message-Id: <200905311432.n4VEWowv020762_at_mail97c0.megamailservers.com>

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

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

Received on Sun May 31 2009 - 09:32:53 CDT

This message: [ Message body ]
Next message: Stephane Faroult: "Re: Guidelines for avoid Bind Variable Peeking behavior"
Previous message: troach_at_gmail.com: "Re: Guidelines for avoid Bind Variable Peeking behavior"
In reply to: Roberto Veiga: "Guidelines for avoid Bind Variable Peeking behavior"
Next in thread: Stephane Faroult: "Re: Guidelines for avoid Bind Variable Peeking behavior"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message