Re: bloom filter not used after 19C upgrade
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 9 May 2024 09:46:42 +0100
Message-ID: <CAGtsp8=DVZfZtc2uQVQTOS86mDyGKZ8WZuR6gDRpJ28Pc+GtXw_at_mail.gmail.com>
Date: Thu, 9 May 2024 09:46:42 +0100
Message-ID: <CAGtsp8=DVZfZtc2uQVQTOS86mDyGKZ8WZuR6gDRpJ28Pc+GtXw_at_mail.gmail.com>
It's actually v$sql_join_filter.
Regards
Jonathan Lewis
On Thu, 9 May 2024 at 07:33, Lothar Flatz <l.flatz_at_bluewin.ch> wrote:
> V$SQL_JOIN? What the hack?
>
> Am 09.05.2024 um 02:53 schrieb Mladen Gogala:
>
>
> 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.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 09 2024 - 10:46:42 CEST