2.1.14.11 Faster Hash Joins on Large Tables

A Bloom Filter is a data structure used to efficiently check if an element is a member of a set. Exadata Smart Scan uses Bloom Filters to perform hash joins inside the storage servers.

In conjunction with Oracle Database 23ai, Oracle Exadata System Software release 24.1.0 relaxes the previous internal limitation on the maximum size of a Bloom Filter sent to the storage servers. By enabling larger Bloom Filters, Exadata Smart Scan can perform more efficient hash joins with substantially faster results, especially on complex join queries involving large tables.