Skip to Main Content

Database In-Memory Office Hours

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

Header container

April 20, 2018

Join Performance
Andy Rivenes (@TheInMemoryGuy) and Maria Colgan (@SQLMaria) focused on a deep dive into hash joins and how they are used with Database In-Memory to make joins lightning fast. The session began by reviewing how traditional hash joins work and then addressed Bloom filters and how Database In-Memory uses them to effectively turn hash joins into scan and filter operations. The use of Join Groups was then discussed as a way to further enhance join performance in 12.2 and beyond.

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

Ask a Question

Ask The Experts - Right Now!

Do you have a question about Join Performance. you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.

Experts

Your Experts
Andy Rivenes
Andy Rivenes, Product Manager    
Andy Rivenes is a Product Manager at Oracle for Database In-Memory. Prior to that Andy was a Product Manager for Heat Map, Automatic Data Optimization, SecureFiles and DBFS. Andy has spent a large part of his career managing Oracle databases and he now spends his time helping customers implement Database In-Memory as well as providing information about Database In-Memory through blogs, conferences, and customer visits. You can visit the Database In-Memory blog at https://blogs.oracle.com/in-memory or follow his tweets as @TheInMemoryGuy.
Maria Colgan
Maria Colgan, Master Product Manager    
Maria Colgan is a master product manager at Oracle Corporation and evangelist for Oracle Database, which she's worked with since version 7.3. In an earlier life, she was the product manager for Oracle Database In-Memory and the query optimizer.