Re: Count(*) Versus Count(1)

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 2 May 2007 23:02:00 -0700
Message-ID: <1178172120.410264.249160@y80g2000hsf.googlegroups.com>

On May 3, 9:21 am, Priya <supriyarsh..._at_gmail.com> wrote:
> Hi,
>
> I Read on Many sites about Count (*) and Count(1). But there are
> conflicts in the documents.
> Some where it has been specified like count (*) gives better
> performance and somewhere it is like Count (1) gives better
> performance.
>
> Can anybody please help me to understand how it works and which one is
> better for performance?
>
> Any help would be appreciated.
>
> Thanks

http://www.oracledba.co.uk/tips/count_speed.htm, Google archives, numerous other places. To sum up: there are no significant differences in performance between count(*) and count(1) beyond usual experiment error, and Oracle does exactly the same amount of work for both.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Thu May 03 2007 - 01:02:00 CDT