Re: Is Parallelism happening at INSERT level?
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Wed, 6 May 2020 18:21:13 +0100
Message-ID: <CAGtsp8=0-U6u4RZxp7yuFMnwY=7fXTGdV5JA8_Mh5HvH_g9E_A_at_mail.gmail.com>
Date: Wed, 6 May 2020 18:21:13 +0100
Message-ID: <CAGtsp8=0-U6u4RZxp7yuFMnwY=7fXTGdV5JA8_Mh5HvH_g9E_A_at_mail.gmail.com>
Until 19c a query that uses a Bloom filter will "lose" the Bloom filter
when it's changed to "insert as select".
However CTAS does work, and there is a patch, that allows insert /*+ append
*/ as select to use a Bloom filter.
See blog and comments:
Regards
On Wed, May 6, 2020 at 4:04 PM Lothar Flatz <l.flatz_at_bluewin.ch> wrote:
> Hi,
https://jonathanlewis.wordpress.com/2016/07/08/dml-and-bloom/
Jonathan Lewis
>
> I wonder if a Bloom Filter could be used on sce. Would that be faster than
> probing? I would think so ...
> There seems to be many rows not surviving the join.
>
> Regards
>
> Lothar
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 06 2020 - 19:21:13 CEST