 |
 |
Archives of the TeradataForum
Message Posted: Wed, 30 Jun 2004 @ 21:57:31 GMT
| Subj: | | Stored procedures and updating seq number with a cursor for loop |
| |
| From: | | SIMPSON, PAMELA |
I was wondering if you have heard of stored procedures taking a unacceptable amount of time to execute. The procedure that I am running is
taking almost 2 hours. This procedure is updating a seq number for 58000 rows with a cursor for loop. They have told me that there is not a
problem with the development database which has 207 amps.
Hope you can answer my question.
Sincerely,
Pamela Simpson
| |
