Archives of the TeradataForum
Message Posted: Mon, 14 Nov 2005 @ 14:44:17 GMT
Subj: | | Re: Stored procedures results |
|
From: | | Glen Blood |
Sorry to disagree
| "We have never needed SP in Teradata and the main reason they seem to be there now is because Oracle required them to do most anything
productive." | |
I use them extenisvely in my automated infrastructure. The ability to use dynamic SQL and DDL is invaluable. The way I usually use them
is to create the SQL (sometimes using cursors) on the fly and running it dynamically. By doing it this way, you lose none of the Parallelism of
Teradata.
I have created an automated space management system using Stored Procedures. I have also created Aggregation Routines for my applications.
They are a vast improvement in the capabilities of the system.
Glen
|