Re: Anyone run across Bug 6503543 Suboptimal plan due to bad cardinality estimate for RANGE join predicates

From: Charles Schultz <>
Date: Wed, 18 Feb 2009 09:05:51 -0600
Message-ID: <>


I was unable to reproduce this issue in Ironically, even though the bug is for RANGE predicates, the query in question is using an EQUALITY predicate. So I have to assume we are hitting some bug that is giving us an ultra low selectivity (incorrectly) under specific situations in, but no longer in

On Tue, Feb 17, 2009 at 8:11 AM, Charles Schultz <>wrote:

> Good day, list,
> I was doing some tuning on a VPD view (a view that calls tables with FGAC
> policies) and the 10053 trace exhibited a gigantic index selectivity that
> surprised me. Curious if anyone else had run across this. I usually check
> out Jonathan Lewis's ScratchPad and look for notes from Richard Foote,
> Alberto Dell'Era, Greg Rahn and many others, but so far I have not seen that
> anyone hit this (of course, I was using google, so....). I am using a
> database, for which the bug is specifically filed, supposedly fixed
> in
> For those that like more information:
> --
> Charles Schultz
> Sent from: Champaign Illinois United States.

Charles Schultz
Sent from: Champaign Illinois United States.

Received on Wed Feb 18 2009 - 09:05:51 CST

Original text of this message