Archives of the TeradataForum
Message Posted: Tue, 19 Jul 2005 @ 13:32:15 GMT
Subj: | | Re: COALESCE or CASE ? |
|
From: | | Victor Sokovin |
| is internally converted to the equivalent (by definition) CASE statement | |
I wouldn't bet on that with such a certainty. There could be subtle differences between the two which sometimes lead to pretty big differences.
Take a look at the recent thread:
www.teradataforum.com/teradata/20050709_215011.htm
.
It seems to suggest that in the OP's situation CASE did not run at all whereas COALESCE did.
Regards,
Victor
|