Designing Tables and Indexes for Performance › Table Space Performance Recommendations › Use Segmented or Universal Table Spaces › Universal Table Spaces

Universal Table Spaces

DB2 9 introduces a new type of table space that is called a universal table space. A universal table space is segmented and partitioned. Two types of universal table spaces are available:

• The partition-by-growth table space
• The range-partitioned table space

A universal table space offers the following benefits:

• Better space management relative to varying-length rows. A segmented space map page provides more information about free space than a regular partitioned space map page.
• Improved mass delete performance. A mass delete in a segmented table space organization tends to be faster than in table spaces that are organized differently. In addition, you can immediately reuse all or most of the segments of a table.