Re: is it possible in pl/sql?
- From: Steve Jelfs <steve@xxxxxxxxxxxxxx>
- To: davewendelken@xxxxxxxxxxxxx
- Date: Thu, 10 Feb 2005 09:37:44 +0000
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;
>/
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
