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, 2018

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 give us feedback and be notified of upcoming sessions!

Ask a Question

Ask The Experts - Right Now!

Do you have a question about Why are column store scans faster than row store scans. 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.
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.