Skip to Main Content

Breadcrumb

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?

Regards,
Ashish

and we said...

This points to an excellent paper on the subject:

http://antognini.ch/2008/09/bloom-filters/


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

Reviews

Paper missing

May 29, 2020 - 3:26 pm UTC

Reviewer: MrVee from Midwest, USA

Hi,

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

Thanks
Chris Saxon

Followup  

May 29, 2020 - 5:16 pm UTC

It still seems to be available to me:

https://antognini.ch/papers/BloomFilters20080620.pdf