Timesten - In-memory columnar compression

> Database > (TimesTen|TT) (In-Memory Database|IMDB)

1 - About

TimesTen provides the ability to compress tables at the column level, thus storing the data more efficiently.

This mechanism provides space reduction for tables by eliminating the redundant storage of duplicate values within columns and improves the performance of SQL queries that perform full table scans.

3 - Documentation / Reference

  • CREATE TABLE in Oracle TimesTen In-Memory Database SQL Reference.