Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why aren't these queries the same?
On Fri, 08 Mar 2002 23:05:45 GMT, damorgan <damorgan_at_exesolutions.com> wrote:
>As long as you are looking to speed things up ... try replaeing count(*) with
>count(1) or count(rowid).
>
>Daniel Morgan
>
>
>
<snip>
That part was a simplification of the original statement. Relative to the question posed, the actual column selection is irelevent.
-- Ed Stevens (Opinions expressed do not necessarily represent those of my employer.)Received on Mon Mar 11 2002 - 08:12:55 CST