Archives of the TeradataForum

Message Posted: Fri, 15 Mar 2002 @ 18:04:02 GMT

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

Jeremy,

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.

Thanks,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

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