Re: Is Parallelism happening at INSERT level?

Thanks Jonathan, I think this is really useful. I already wondered before about missing bloom filters. :-)

Am 06.05.2020 um 19:21 schrieb Jonathan Lewis:
>
> 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:
> https://jonathanlewis.wordpress.com/2016/07/08/dml-and-bloom/
>
> Regards
> Jonathan Lewis
>
>
>
>
>
> On Wed, May 6, 2020 at 4:04 PM Lothar Flatz <l.flatz_at_bluewin.ch
> <mailto:l.flatz_at_bluewin.ch>> wrote:
>
> Hi,
>
> 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-l