Storage Management Query Bands | Teradata Vantage - 17.10 - Reserved Storage Management Query Bands - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)
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.
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)