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.
