Skip to Main Content

General Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

June 17, 2021

13:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Bloom filters, hash joins and why indexing should scare you
When you see the term "bloom filter" in your execution plan, what does that mean? We explored this and answered your other questions in this months general database Office Hours.

- Bloom filters
- UTL_FILE_DIR desupport
- The risks with indexes
- Hash joins with NOT IN
- How to get the SQL_ID for a SQL text

Your Experts

    Connor McDonald

    Connor McDonald   

    Connor McDonald is a former Oracle ACE Director who has joined the Oracle Developer Advocates Team. He has co-authored three books, is a popular speaker at Oracle conferences around the world, and is best known as a member of the AskTOM team.