Teradata Cookbook

Solving insert performance

Insert comes under  data manipulation language. Insert means to place a new row into a table, which could be a duplicate or unique in itself.

The basic syntax of insert goes like this:

INSERT INTO table_name [(col_name [, ..., col_name])]VALUES (expression [, ..., expression]);

A variation called INSERT SELECT takes data from an already populated table and inserts it into another one:

INSERT INTO table_name [(col_name [, ..., col_name])] SELECT statement;