Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2003 @ 14:34:48 GMT


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

Subj:		Re: Tearadata SP and ASP

From:		Doug Little

Deiter

Given your statement

"Regarding cursors, every DBMS has performance problems with cursors, because cursors are processed serially, whereas a DBMS is optimized for set operations. On Teradata it's especially bad, because a SP runs on one node only using a single CPU."

If teradata sp's are executed concurrently from different sessions, or within the same session, will they execute concurrently or serially?

Typically sp's are small row level processes that are being executed by triggers and/or clients. So the parallelism comes from having multiple calling clients, not from within the dbms.

Thoughts?

Thanks

Doug Little