Archives of the TeradataForum

Message Posted: Mon, 15 Dec 2008 @ 08:19:08 GMT

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

<-- Anonymously Posted: Sun, 14 Dec 2008 19:58 -->

Cursors are not a strength of Oracle. Cursors preclude set based processing from occurring on all SQL database implementations. I was on a project and the Oracle team that handled application database requirements were begging for the chance to re-write their application because the cheap contractors they hired implemented cursors in pandemic fashion and their performance was in the toilet.

I although recent threads seem to have corrected the popular misconception that stored procedures are patently bad on Teradata. If the SP does not use a cursor then you�ll going to be as parallel with a stored procedure as one without.

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