Archives of the TeradataForum
Message Posted: Thu, 11 Sep 2003 @ 09:26:36 GMT
Teradata is a Parallel architecture and likes doing Mulitple things at the same time. If you apply a Cursor you are SERIALIZING your operation and defeating the strength of Teradata.
Try to see if there is a way to apply the work you are doing by Looping through each row via an SQL statement wich can work across the whole table at once.
If the LOOP is to eliminate some rows from the result, try adding a WHERE clause to eliminate those rows rather than looking at each row individually.
If you are calculating a Mean or STD DEV or somthing like that try one of the built-in Teradata OLAP functions or come V2r5.1 you can define your own UDF which will work inside the parallel nature of teradata
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|