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 Vantage.
- BlockCompression. For more information, see BlockCompression Reserved Storage Management Query Bands.
- TVS Temperature. For more information, see TVSTemperature Reserved Storage Management Query Bands.
The following SQL statements also support storage management query bands.
- ALTER TABLE (see ALTER TABLE (Basic Table Parameters))
- CREATE HASH INDEX (see CREATE HASH INDEX)
- CREATE JOIN INDEX (see CREATE JOIN INDEX)
- CREATE TABLE … AS … WITH DATA (see CREATE TABLE (AS Clause))
CREATE HASH INDEX, CREATE JOIN INDEX, and CREATE TABLE … AS …WITH DATA immediately populate the hash or join index subtable or new table with column values from the tables they reference, similar to a load operation.
- INSERT into an empty table (see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146)
- INSERT … SELECT into an empty table (see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146)
- MERGE inserts into an empty table (see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146)