Re: count (1) and count (*)
Date: Wed, 29 Oct 2003 11:25:47 -0500
Message-ID: <LvSdnZaAJfOzdwKiRVn-vQ_at_comcast.com>
it used to be true prior to somewhere in v7 -- should not be true anymore, but it's always good to do an EXPLAIN PLAN or SET AUTOTRACE ON to make sure
- mcs
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news: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 - 17:25:47 CET