Re: count (1) and count (*)
From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 29 Oct 2003 15:29:43 GMT
Message-ID: <H1Rnb.40108$mZ5.224243_at_attbi_s54>
Date: Wed, 29 Oct 2003 15:29:43 GMT
Message-ID: <H1Rnb.40108$mZ5.224243_at_attbi_s54>
"Geetha" <gelangov_at_hotmail.com> wrote in message
news:4b40e20a.0310290724.13e86079_at_posting.google.com...
> I searched in the Oracle documents what count (1) meant and I could
> not find an answer. Can some one explain what Oracle does internally
> when use count (1) VS count (*). Thank you very much in advance! We
> use Oracle 9i.
There is a myth out there that count(1) is faster than count(*). It isn't
true. Use count(*).(You can look it up on asktom.oracle.com)
Jim
Received on Wed Oct 29 2003 - 16:29:43 CET