Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question.

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

Last updated: May 29, 2020 - 5:16 pm UTC

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 Tom 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.

Rating

  (1 rating)

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

Comments

Paper missing

MrVee, May 29, 2020 - 3:26 pm UTC

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
May 29, 2020 - 5:16 pm UTC

It still seems to be available to me:

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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.