Archives of the TeradataForum
Message Posted: Mon, 26 Jan 2009 @ 16:56:20 GMT
<-- Anonymously Posted: Mon, 26 Jan 2009 11:56 -->
Are the loops iterating through a cursor (or multiple cursors)? Cursor fetch is inherently a sequential operation and does not exploit the parallel capabilities of the Teradata platform.
Best practice is to redesign the logic to use "set processing" rather than iteration.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|