Wednesday, April 22, 2009

Q4U: R U Cmprsng UR DTA?

DAMHIKT, but it seems stuffing more in less space is popular (try going on vacation with a family). Fortunately, the next release of DB2 adds a lot of compression features. On the page for the Technology Sandbox (a.k.a. "beta") the following compression functionality is mentioned in addition to DB2's deep table compression:
AAF I can tell U that this is cool stuff.

Index compression saves you big because you usually have plenty of them and compressed indexes are still compressed when in the bufferpool. Compression of temporary tables is especially useful for analytics/warehousing. Sign up and test it yourself!


CU, Henrik (DARFC)

BTW: I got some help coding parts of my blog using this abbreviation list.