Archives of the TeradataForum

Message Posted: Mon, 14 Nov 2005 @ 11:22:16 GMT

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

Hi Eric:

What you seem to be ignoring in your opinion posting is that Teradata SQL does everything in parallel and provides many operations and techiques that other database do not allow. 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. Now those same Oracle databases are running out of gas because of all the SP's as databases exceed 5 TB in size. Therefore, they are becoming Teradata sites but do not want to change the habits developed in the previous failed efforts. You say you had to develop 100 SPs for branching decisions? Interesting to say the least.

The big problem with a SP is that everything SPL does is pretty much serial in nature. Therefore, it bottlenecks the execution after the SQL finishes for things would otherwise continue as parallel if done entirely in SQL.

Beyond that, if I understand your posting correctly, you seem to be saying that Teradata does not have dynamic SQL? Teradata SP's do have dynamic SQL that you can build from data stored in the DBC views and execute them immediately as part of the SP. From my perspective, this is the best thing to do in a SP to facilitate DB Admin type of operations.

Of course, that is my opinion and you know what they say about opinions, everyone has one...lol

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
Teradata SQL - Unleash the Power

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