16.20 - Reserved Storage Management Query Bands - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
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 Teradata Database.
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 )