Skip to Main Content

Breadcrumb

Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

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