Archives of the TeradataForum

Message Posted: Mon, 15 May 2006 @ 16:15:02 GMT

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

Chirag,

You can use Cursors in Stored Procedures in Teradata. However, I recommend that you don't just 'copy' over the current logic. You should really evaluate whether the current logic can be replaced by something else more efficient. SET logic (processing of multiple rows at time) can often replace most of the logic used in CURSORS. It will also run faster 99.999% of the time. However, the load techniques really depend on three factors:

1) Frequency of data arrival

2) volume of data

3) How fast you can react to/use the data loaded? Don't use a more expensive technique just because you can or are used to it.

Thanks,

Bob Diehl
Travelocity.com

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