Bulk Insert String

Bulk Insert String is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Bulk Insert String property appends the string provided in front of the INSERT statement. For Teradata, this property is set to ";" to increase query performance. The string is appended only for the INSERT INTO SELECT statements and not the INSERT INTO VALUES statement that is generated by the Analytical Engine. Since the string is appended for the INSERT INTO SELECT statement, this property takes effect only during explicit, permanent, or temporary table creation.

Levels at Which You Can Set This

Database instance, report, and template

Bulk Insert String = ;