From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 29 Oct 2003 15:19:40 -0800
Message-ID: <3722db.0310291519.40f3f59_at_posting.google.com>
Date: 29 Oct 2003 15:19:40 -0800
Message-ID: <3722db.0310291519.40f3f59_at_posting.google.com>
I read somewhere (asktom?) that "select count(1) from table" is
internally rewritten as "select count(*) from (select 1 from table)",
and therefore just adds some overhead.
Daniel
gelangov_at_hotmail.com (Geetha) wrote in message news:<4b40e20a.0310290724.13e86079_at_posting.google.com>...
> 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.
Received on Thu Oct 30 2003 - 00:19:40 CET