New column-organized table option for DB2 databases

Starting with DB2® Version 10.5, you can create tables that are stored with column organization. New capabilities for processing vectors of column data instead of individual values are in-memory optimized, CPU optimized, and I/O optimized.

DB2 Version 10.5 introduces enhanced support for analytic workloads, including compressed column-organized tables for DB2 databases. Analytic workloads have complex queries that are commonly characterized by multi-table joins, grouping and aggregation, and table scans over a star schema.

Advantages include significantly reduced time-to-value and increased consumability, which you can achieve through minimal design requirements and reduced query tuning and debugging. Industry-leading compression, large performance gains for analytic queries, and large reductions in performance variation round out the benefits of deploying this technology.

Column-organized and row-organized tables can coexist in the same database, schema, table space, or query. If an analytic query references a column-organized table, the best performance is typically achieved when all the other referenced tables (if any) are also column-organized.