Re: Bloom Filter Partition Pruning

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: jaromir@xxxxxxxxxxxx
  • Date: Fri, 16 Mar 2018 02:28:36 +0300

 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

Other related posts: