RE: is it possible in pl/sql?

I agree. They are the same.

-----Original Message-----
From: Steve Jelfs [mailto:steve_at_trolltec.co.uk] Sent: Thursday, February 10, 2005 4:38 AM To: davewendelken_at_earthlink.net
Cc: 'oracle-l_at_freelists.org'
Subject: Re: is it possible in pl/sql?

Not sure about count(1) being more efficient. I, personally, have never seen any evidence for that!
Steve

david wendelken wrote:

>Gosh, the original programmer was somewhat confused about what they are
doing and/or coding in general and/or coding in pl/sql.
>
>[snip]
>
> -- count(*) is wasteful. count(1) is more efficient.
> sqlstmt := 'UPDATE myTables SET new_Rows = (select count(*)
>from ' || x.Table_Name|| ') WHERE Table_Name = ' || x.Table_Name||';
> -- execute dynamic sql
> END;
>END LOOP;
>end;
>/
>
>
>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l