Re: Optimization question: Unrolling subquery into IN clause

From: Wolfram Roesler <wr_at_spam.la>
Date: Tue, 20 Oct 2009 13:58:45 +0000 (UTC)
Message-ID: <Xns9CAAA28DE3BE2wrgrpde_at_news.albasani.net>

Ind-dba <oraclearora_at_googlemail.com> wrote in news:0a668e04-8222-4746-aeb3-f4d878fcfe32_at_b3g2000pre.googlegroups.com:

...
> SELECT /*+ cardinality(20) */ key
...

That changes nothing.

> If parameters are passed as binds - could you rewrite the query with a
> dummy comment to confirm the sql gets parsed again - this is rule of
> any bind peeking/histogram effect. Do you have histograms on the
> table/ columns?

There are no histograms.

Thanks for your help
W. Rösler Received on Tue Oct 20 2009 - 08:58:45 CDT