Re: bloom filter not used after 19C upgrade

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

Am 08.05.2024 um 21:42 schrieb Laurentiu Oprea:
> Dear all,
>
> I`m trying to figure out why a query is not using part join bloom
> filter after the 19C upgrade.
>
> In 10053 KkoBloomFIlter messages are: accepted, but final
> decision will be made in code generation. But in the final execution
> plan it is using partition range all..
>
> WHere should I look for hints to understand what exactly went wrong?
>
> Appreciate your help.

--
http://www.freelists.org/webpage/oracle-l