Question & Answer
Question
在测试中，我发现列式存储表比进行了压缩的行式存储表占用的空间要多。同时观察到SYSCAT.TABLES中的PCTPAGESSAVED字段，列式表的值小于10%而行式表则高达60%多。因此主要是压缩效率太低导致列式表占用了更多空间，是否能够提高列式表的压缩率呢？
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
swg22015140