15.00 - Reserved Query Bands for Managing the Block-Level Compression and Storage Temperature of Newly Loaded Data - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Reserved Query Bands for Managing the Block-Level Compression and Storage Temperature of Newly Loaded Data

The BlockCompression and TVSTemperature reserved query bands enable you to control various aspects of loading new data into tables. For more information on the TVSTemperature query band, see Teradata Virtual Storage.

Note: These query band names are reserved for use by Teradata Database and by Teradata partners and should not be used by customers.

The BlockCompression reserved query band controls the compression of data loaded into a primary data table, join index, or hash index at the data block level using the following data loading methods:

  • Archive and Restore
  • Teradata Archive/Recovery Utility Reference

  • DUL csp command
  • See Utilities: Volume 1 (A-K)

  • FastLoad
  • See Teradata FastLoad Reference

  • MultiLoad
  • See Teradata MultiLoad Reference

  • JDBC Embedded FastExport
  • See Teradata JDBC Driver User Guide

  • JDBC Embedded FastLoad
  • See Teradata JDBC Driver User Guide

  • Teradata Parallel Transporter Load, Update, and Export operators
  • See Teradata Parallel Transporter Reference

  • CREATE HASH INDEX requests
  • See SQL Data Definition Language

  • CREATE JOIN INDEX requests
  • See SQL Data Definition Language

  • CREATE TABLE … AS … WITH DATA
  • See SQL Data Definition Language

  • INSERT requests into an empty table
  • See SQL Data Manipulation Language

  • INSERT … SELECT requests into an empty table
  • See SQL Data Manipulation Language

    The BlockCompression reserved query band indicates whether data being loaded into an empty table that is using a form of manual compression should be compressed at the data block level or not. The term manual compression as used here refers to column‑level compression methods such as multi-value compression and algorithmic compression. See “Block-Level Compression” on page 704 for more information about this. The TVSTemperature reserved query band controls the desired TVS‑managed temperature level for the cylinders that store the newly loaded data for both manually‑managed tables and temperature‑based‑managed tables, which can be specified to be Cold, Warm, or Hot. See “Temperature‑Based Block-Level Compression” on page 705 for more information about this.