DB2 9: Row compression and large RIDs

Consider large RIDs on row compression in DB2 9

From the developerWorks archives

Peter Schurr

Date archived: January 12, 2017 | First published: July 05, 2007

This article describes the impact of large row IDs (RIDs) on the row compression feature in DB2 for Linux, UNIX, and Windows. Both large RIDs and row compression features were introduced in DB2 9. Row compression can significantly reduce the average row size, but when not using large RIDs, you are limited by the regular tablespace limits of 255 rows per page. By examining a simple test case of the table ORDERS from the TPCH database, you'll see how using large RIDs can circumvent the limits on the number of rows per page, a relevant factor for optimizing the benefits of row compression.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=237759
ArticleTitle=DB2 9: Row compression and large RIDs
publish-date=07052007