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

March 28

17:00 UTC   Start Times Around the World


Why are column store scans faster than row store scans
This In-Memory Office Hours session explored why Database In-Memory scans are so much fast than traditional row-store scans. We answered the basic question "Why not just cache the entire table in the buffer cache?" by describing the technology used by Database In-Memory and then showing a demonstration of running the same query with Database In-Memory enabled and the table fully cached in the buffer cache. Watch the session and see for yourself why Database In-Memory is so much faster.

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.

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 or follow his tweets as @TheInMemoryGuy.
Gregg Christman
Gregg Christman, DB Performance Senior Product Manager    
Product Manager responsible for Advanced Compression, Hybrid Columnar Compression, Information Lifecycle Management (Heat Map and Automatic Data Optimization), Flashback Data Archive and In-Database Archiving.