Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

Best practices for storing data in column-organized tables 

Wed July 16, 2025 01:13 PM

The paper refers to operations that are covered by the companion paper, Best Practices to Compress Db2 Column-Organized Tables. Ensure that you have read this paper first.

The following areas are covered by Best practices for storing data in Db2 column-organized tables:

  • Storage of table data.
  • Measuring storage for a column-organized table.
  • Storage overhead when using column-organized tables.
  • The impact of synopsis tables on column-organized table storage.
  • Operations that impact storage.
  • Best practices for working with column-organized table storage.

Statistics
0 Favorited
1 Views
1 Files
0 Shares
1 Downloads
Attachment(s)
pdf file
BLU_Storage_Best_Practices_version_20230824_uploaded_on_2....pdf   882 KB   1 version
Uploaded - Wed July 16, 2025