Skip to Main Content


Question and Answer

Tom Kyte

Thanks for the question.

Asked: December 18, 2011 - 9:42 pm UTC

Answered by: Tom Kyte - Last updated: May 29, 2020 - 5:16 pm UTC

Category: Database - Version: 11.2

Viewed 10K+ times! This question is

You Asked

Hi Tom,
What are bloom filters? Is it new in 11g?
How does it improve performance? How can I check, if bloom filter is happening in the DB or not?


and we said...

This points to an excellent paper on the subject:

Christian Antognini is a trusted source of information about Oracle, the paper he developed on this is pretty awesome.

and you rated our response

  (1 rating)

Is this answer out of date? If it is, please let us know via a Review


Paper missing

May 29, 2020 - 3:26 pm UTC

Reviewer: MrVee from Midwest, USA


We can only find the scripts used for testing in Christian Antognini's website. Does anyone have the link to the paper

Chris Saxon


May 29, 2020 - 5:16 pm UTC

It still seems to be available to me: