Re: Bloom Filter Partition Pruning

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 16 Mar 2018 02:28:36 +0300
Message-ID: <CAOVevU40iRzpc_tBZJAZ6=dNE_4YpJ_Zrk81_MnAXTJtqdVe1g_at_mail.gmail.com>

Jaromir,

That's pretty simple for HASH partitioning: Oracle can use hashes of elements for BF the same way as it uses them for usual partition pruning for hash-partitioned tables, so all that we need is just number of partitions (
https://jonathanlewis.wordpress.com/2009/11/21/ora_hash-function/)

--

Best regards,
Sayan Malakshinov
http://orasql.org

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 16 2018 - 00:28:36 CET

This message: [ Message body ]
Next message: Stefan Koehler: "Re: From ORACLE-L to DATABASE-L?"
Previous message: Kellyn Pot'Vin-Gorman: "Re: OEM in AWS"
In reply to: Jaromir D.B.Nemec: "Bloom Filter Partition Pruning"
Next in thread: Jaromir D.B.Nemec: "RE: Bloom Filter Partition Pruning"
Reply: Jaromir D.B.Nemec: "RE: Bloom Filter Partition Pruning"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message