15.00 - Set Processing Alternative - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Set Processing Alternative

For situations where row-at-a-time maintenance imposes table‑level locking, consider updating the base table with periodic set processing approaches. The following example shows a set processing approach to updating the customer table, using frequent, short INSERT … SELECT operations into the base table that also update its associated multitable and aggregate join indexes.