Archives of the TeradataForum

Message Posted: Tue, 19 Jul 2005 @ 10:41:20 GMT

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

COALESCE seems to be the way to go here. In fact, it is just a special case of a CASE statement, and its mere existence as a separate command in TD should be probably justified by better handling of NULLs, I would assume.

It is, however, possible that in this example the CASE will be internally rewritten and handled in the same way as COALESCE, and you won't notice any differences in performance. Perhaps you could just try both options on you particular version of TD and see whether there are any differences at all.

Regards,

Victor

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