Re: Optimization question: Unrolling subquery into IN clause
Date: Tue, 20 Oct 2009 13:58:45 +0000 (UTC)
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