
40 Unleashing DB2 10 for Linux, UNIX, and Windows
3.3.1 Creating new tables with adaptive compression
The compression options in DB2 10 are available through new syntax in the
CREATE TABLE statement shown in Example 3-1.
Example 3-1 Compression clause in the CREATE TABLE statement
.-COMPRESS NO---------------.
>-----+---------------------------+---->
| .-ADAPTIVE-. |
'-COMPRESS YES-+----------+-'
'-STATIC---'
For new tables that are created in Great Toque Outdoors’ database, adaptive
compression is applied by default when the following statement is issued:
CREATE TABLE … COMPRESS YES
This statement is the equivalent of explicitly issuing the f ...