What does the Exadata Server software use Bloom Filters for?
A.
Join filtering
B.
Query optimization
C.
Cardinality analysis
D.
Sorting
Explanation:
Join filtering is not something specific to the Exadata Storage Server. In fact, it is an
Enterprise Edition feature available since Oracle Database 10g Release 2. Simply put, it is used to
reduce data communication between slave processes in parallel joins.
http://antognini.ch/2010/05/exadata-storage-server-and-the-query-optimizer-part-3/Reference: http://antognini.ch/papers/BloomFilters20080620.pdf