Best practices for storing data in Db2 column-organized tables
Best Practices for Storing Data in Column-Organized Tables describes the recommended practices to reduce storage consumption when working with BLU tables.
- Authors:
- Ron Liu
Best practices for storing data in Db2 column-organized tables is a companion to Best Practices to Compress Db2 Column-Organized Tables and contains references to operations covered in that document. Ensure that you are familiar with these operations first.
The paper covers basic concepts on how table data is stored and how to retrieve information regarding storage space. It also contains descriptions of common database operations and their impact to storage, as well as best practices for minimizing table storage consumption.
The following information is examined in detail:
- Storage of table data.
- Measurement of storage for a column-organized table.
- Storage overhead when working with column-organized tables.
- The impact of synopsis tables on column-organized table storage.
- Operations that impact storage.
- Best practices for data storage in column-organized tables.