Customer-written applications must not use these query band names. They are reserved for use by Teradata-written applications and applications written by third party Teradata partners.
The primary and fallback subtables of a table can have independent block-level compression attributes.
You can use the BlockCompression query band with tables whose effective BLOCKCOMPRESSION attribute is MANUAL. In that case, the query band indicates if the data being loaded into an empty primary or fallback table (or both) is to be compressed at the data block level.
For Object File System tables, BLOCKCOMPRESSION has a default value that you cannot change.
The specifications apply to permanent or global temporary table data, but do not apply to Spool data or Permanent Journal data.
The valid BlockCompression values apply, as noted, to primary data tables, fallback data tables, and work tables.
BlockCompression indicates if the data being loaded into an empty primary or fallback table (or both) is to be compressed at the data block level. See Block-Level Compression and Tables.
| Value | Description |
|---|---|
| ALL | Compress all new primary and fallback table data at the data block level. This option is equivalent to specifying YES. |
| FALLBACK | Compress new fallback data, but do not compress primary table data. |
| FALLBACKANDCLOBS | Compress fallback data, including fallback and primary LOBs that are eligible for compression. |
|
These options are equivalent and specify not to compress new primary and fallback table data at the data block level. |
| ONLYCLOBS | Compress only new LOB data that is eligible for compression. |
| WITHOUTCLOBS | Compress all data, except for LOB data. |
| YES | Compress all new primary and fallback table data at the data block level. This option is equivalent to specifying ALL. |
The following table summarizes the effects on data of the BlockCompression query band settings.
| Value | Primary Table | Fallback Table | Primary Subtable Compressible LOBs | Fallback Subtable Compressible LOBs |
|---|---|---|---|---|
| None | Default | Default | Default | Default |
| ALL | Compressed | Compressed | Compressed | Compressed |
| FALLBACK | Not compressed | Compressed | Not compressed | Compressed |
|
Not compressed | Not compressed | Not compressed | Not compressed |
| ONLYCLOBS | Not compressed | Not compressed | Compressed | Compressed |
| WITHOUTCLOBS | Compressed | Compressed | Not compressed | Not compressed |
| YES | Compressed | Compressed | Compressed | Compressed |