Re: Code review... gurus required!

From: Christoph Purrucker <gugi_at_bigfoot.de>
Date: Thu, 17 Jul 2003 12:02:16 +0200
Message-ID: <bf5s7i$8el$1@home.itg.ti.com>

Hello Steve,

> select nvl(count(*),0) into variable
>
> ...and I'm not sure if it is necessary! Do you need the nvl() function
> in this pl/sql statement, and will its removal speed things up?
>
> I reckon no and yes, but would appreciate the experts view!

for that, You don't need any expert, because count(*) "never returns null", so nvl() is obsolete. The performance advantage will be very small since nvl() is no heavy-weight function. But when You have to do a code review, I would expect Your result is faster and more readable, so You have to strike out any obsolete code.

cu cp Received on Thu Jul 17 2003 - 05:02:16 CDT