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.
The following SQL statements also support storage management query bands.
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.