Archives of the TeradataForum
Message Posted: Fri, 15 Mar 2002 @ 18:04:02 GMT
While I've never found this to be the case in almost 10 years working with Teradata, I'll have to take your word that the logic is too much for SQL.
I believe the answer to your questions is no, it is not doable in a Stored Procedure.
User Defined Functions are targeted for V2 R5.1 to provide this type of logic at the amp level through C code written by you to an API of amp operations / functions for access to standard parallel operations like sort, group, etc...
Stored Procedures really bring the application interface into the RDBMS and operate with a single session and one row at a time. I'd guess that the performance issue isn't the speed of the cursor but the speed of the update operation being executed one row at a time from a single session. The delay between each submission and response causes the entire serial process to appear slow.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|