--- SZCS Gbor <surrano(at)mailbox(dot)hu> wrote:
> It seems that COALESCE(myfunc(),0) has almost
> twice the time of
> calling myfunc() alone! However, using two
> COALESCE's in a CASE does not
> double the time again.
>
Perhaps this is just avoiding the issue (if indeed
there is an issue), but why not just define myfunc()
to return zero instead of null?
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com