15.00 - Reserved Storage Management Query Bands - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Reserved Storage Management Query Bands

Note: Customer‑written applications should not use these query band names. They are reserved for use by Teradata‑written applications and applications written by third party Teradata partners.

The following query band names are reserved for use by Teradata Enterprise Applications and partner applications for storage management resources because they are directives to Teradata Database.

  • BlockCompression (see “BlockCompression Reserved Storage Management Query Bands” on page 870 for more information).
  • TVS Temperature (see “TVSTemperature Reserved Storage Management Query Bands” on page 872 for more information).
  • The following SQL statements also support storage management query bands.

  • ALTER TABLE (see “ALTER TABLE (Basic Table Parameters)” on page 31)
  • CREATE HASH INDEX (see “CREATE HASH INDEX” on page 322)
  • CREATE JOIN INDEX (see “CREATE JOIN INDEX” on page 340)
  • CREATE TABLE … AS … WITH DATA (see “CREATE TABLE (AS Clause)” on page 656)
  • CREATE HASH INDEX, CREATE JOIN INDEX, and CREATE TABLE … AS …WITH DATA are treated as data loading utilities because when you successfully submit them, Teradata Database immediately populates the hash or join index subtable or new table with column values from the tables they reference. Therefore, these CREATE requests are also load jobs.

  • INSERT into an empty table (see SQL Data Manipulation Language)
  • INSERT … SELECT into an empty table (see SQL Data Manipulation Language)
  • MERGE inserts into an empty table (see SQL Data Manipulation Language)