Archives of the TeradataForum

Message Posted: Tue, 27 May 2008 @ 15:40:26 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

IIUC this is a pretty standard enqueue/dequeue strategy and should work OK.

Another approach, depending on the transaction integrity completeness requirements, would be to serialize the small table updates through a queue table: that is, insert the updates into a queue table, and then have a single "SELECT AND CONSUME" statement paired with an UPDATE into the final target table. One can use a stored procedure for this.

This will serialize the updates for the small table without holding-up the rest of the transaction(s).

jdg

	<Prev	Next>		<<First	<Prev	Next>	Last>>