Re: bloom filter not used after 19C upgrade

From: Mladen Gogala <gogala.mladen_at_gmail.com>
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-l
Received on Thu May 09 2024 - 02:53:29 CEST

Original text of this message