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 Corporationwww.centrexcc.com