bloom filter not used after 19C upgrade
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Wed, 8 May 2024 22:42:39 +0300
Message-ID: <CA+riqSXW+QPs=ic6rFfDFuZHPG3zhdTLE5tgugyLnMZmRAO8WA_at_mail.gmail.com>
Dear all,
Date: Wed, 8 May 2024 22:42:39 +0300
Message-ID: <CA+riqSXW+QPs=ic6rFfDFuZHPG3zhdTLE5tgugyLnMZmRAO8WA_at_mail.gmail.com>
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-lReceived on Wed May 08 2024 - 21:42:39 CEST