What does the Exadata Server software use Bloom Filters for?

The correct answer is A. Join filtering. 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.

Smart Scan Technology

Question

Exhibit

Options

AJoin filtering
BQuery optimization
CCardinality analysis
DSorting

How the community answered

(27 responses)

A
85% (23)
B
4% (1)
C
7% (2)
D
4% (1)

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.

Topics

#Bloom filters#join filtering#Smart Scan#offload optimization

Community Discussion

No community discussion yet for this question.

Full 1Z0-536 Practice