Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why aren't these queries the same?

Re: Why aren't these queries the same?

From: Ed Stevens <Ed_Stevens_at_nospam.noway.nohow>
Date: Mon, 11 Mar 2002 14:12:55 GMT
Message-ID: <3c8cbafe.4916088@ausnews.austin.ibm.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US