UK Oracle User Group

In Memory & The Optimizer

« Return to event

Time: 1:45 PM - 2:45 PM

Track: Track 1

Oracle Database In-Memory introduces a new in-memory only columnar format and a new set of SQL execution optimizations such as SIMD processing, column elimination, storage indexes and In-Memory aggregation.  The Oracle Optimizer is fully aware of the new In-Memory functionality and has adapted its cost model to allow existing query workloads to take full advantage of in-memory columnar tables. This session provides an overview of what has changed with the Optimizer, shows how to understand the new execution plans, and explains how query workloads benefit from in-memory.

Presented by

  • Maria Colgan, Oracle

Attached Documents

PDFIn Memory & The Optimizer

Published: 27.03.2015 - This document is restricted to members