Archives of the TeradataForum
Message Posted: Wed, 17 Dec 2003 @ 15:19:50 GMT
Vikram Singh wrote:
What do you mean by time? Elapsed wall-clock time or Teradata CPU time?
Looks like a ASP problem, so this is out of my scope of knowledge....
If you can replace the SP with a macro, there'll be a difference, when it's called repeatedly. Macros are generally faster than SPs, but you can put more complex code into a SP.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|