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

Home -> Community -> Usenet -> c.d.o.misc -> Re: count(1) vs. count(*)

Re: count(1) vs. count(*)

From: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Tue, 23 Apr 2002 15:30:37 GMT
Message-ID: <3CC57D45.D58F0804@shaw.ca>


http://groups.google.ca/groups?hl=en&safe=off&threadm=3c89ec26.10589506%40news.online.de&rnum=11&prev=/groups%3Fq%3Dcount(*)%2Bcount(1)%2Bgroup:comp.databases.oracle.*%26start%3D10%26hl%3Den%26safe%3Doff%26selm%3D3c89ec26.10589506%2540news.online.de%26rnum%3D11

;-)

Daniel Morgan wrote:
>
> Bricklen Anderson wrote:
>
> > uh oh, this discussion again...
> >
> > Maurice Samuels wrote:
> > >
> > > hi,
> > > can someone explain to me why the count(1) syntax works and is faster than a count(*)?
> > > i looked in the oracle docs and while it doesn't specifically go into the count(1) syntax, it does read
> > > that the count operator works as follows:
> > > COUNT({* | [DISTINCT|ALL] expr})
> > >
> > > then in the EXPRESSIONS section of the docs, it reads that an expression can be text, number, etc.
> > > i'm just a little perplexed by the count(1) syntax.
> > > thanks in advance.
> > > -maurice
> > > samuels_at_seas.upenn.edu
>
> Come on Bricklen, don't just point out the obvious ... stick your neck out and help him. <g>
>
> Maurice ... search the google archives.
>
> How was that for avoiding a confragration.
>
> One of these days I'm going to insert 100,000,000 rows in a table and try it out. Anyone have the time and
> incliniation? If so try: SELECT COUNT(*), SELECT COUNT(1), and SELECT COUNT(ROWID).
>
> Daniel Morgan
Received on Tue Apr 23 2002 - 10:30:37 CDT

Original text of this message

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