Re: bloom filter not used after 19C upgrade
Date: Wed, 08 May 2024 20:53:29 -0400
Message-ID: <8e3c00ac7c41dcb5fa6c0c97017803c443b21e81.camel_at_gmail.com>
On Wed, 2024-05-08 at 23:16 +0200, Lothar Flatz wrote:
> Hi,
>
> You could try hinting the bloom filter and see what happens.
> If I get the message right decision is made at runtime. (Not sure).
> In such case it can make a difference how well the table is cached.
> Need more facts, e.g. both plans.
>
> Thanks
>
> Lothar
Hi Lothar,
I may be mistaken, but if the decision is made at runtime, then it is not
possible to know in advance whether Bloom filters will be used or not. The
only places where it's possible to see it is V$SQL_PLAN and V$SQL_JOIN and
not explain plan.
Other than that, Bloom filters were invented by Mr. Bloom, of the
Bialystock & Bloom fame, from the movie "The Producers". That is what it's
so hard to catch them. BTW, if you decide to watch the movie, a smart
decision by any standard, I'd recommend the Gene Wilder version, rather
than the modern one with Will Ferrell.
Regards
-- Mladen Gogala Database SME https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 09 2024 - 02:53:29 CEST