Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What to Count - WAS Re: Newbie ? - Howto find nbr records in a table
On Fri, 9 Oct 1998 11:58:34 -0400, "Van Messner"
<vmessner_at_netaxis.com> wrote:
>I've been following this thread. In the old days I was told to always use
>count(rowid). Any thoughts?
I believe count(*) is the fastest after the count(index_key). Maybe Oracle implicitely uses count(rowid) in that case.