Database Reference
In-Depth Information
It's important to note that, as shown in Table
16-3
, every version between 11.1 and 12.1 changed the keywords
used to activate a specific data compression method. And, at the same time, each newer release deprecated the
keywords used by the prior release. The only keywords that work in exactly the same way in all releases are:
•
NOCOMPRESS
disables table compression.
•
COMPRESS
enables basic table compression.
Table 16-3.
Different Releases Support Different Table Compression Clauses
Version
Basic Table Compression
Advanced Row Compression
Hybrid Table Compression
11.1
COMPRESS FOR
DIRECT_LOAD OPERATIONS
COMPRESS FOR ALL
OPERATIONS
n/a
11.2
COMPRESS BASIC
COMPRESS FOR OLTP
COMPRESS FOR [QUERY|ARCHIVE]
[LOW|HIGH]
R
OW STORE COMPRESS BASIC
12.1
ROW STORE COMPRESS
ADVANCED
COLUMN STORE COMPRESS FOR
[QUERY|ARCHIVE] [LOW|HIGH]
