Benefits of Oracle In-Memory Database

Using the IMCS enhances Oracle Database performance. It can perform scans, joins, and aggregates at a rapid speed. Business applications, ad-hoc analytical queries, and data warehouse workloads benefit most; databases that only deal with online transaction processes and run short transactions using index lookups benefit less. The benefits of IMCS are:

• Scans many rows and applies filters that use operators such as =, <, >, and IN.

• Queries a subset of columns in a table, for example, selecting 5 of 100 columns.

• Accelerates joins by converting predicates on small dimension tables into filters on a large fact table.

• Supports all existing database features, including High Availability features.

• Requires no application changes.

• Requires fewer indexes.

• Reduces the storage space in memory with fewer pre-built objects that significantly lower processing overhead.