That's rediculous, and I refuse to go through the explanation why again.

Everyone else, use count(*) and ignore the LazyDBAs.

<<MrO>>

----- Original Message -----
From: "Payam Moghtader "
<oracledba-ezmlmshield-x32666283.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, September 06, 2007 9:53 AM
Subject: RE: Count function


> Counting a numeric literal is always faster than anything else, even
rowid.
> No row access is required for counting a literal. Logical result is the
> same.
>
> --Payam Moghtader
> www.2dev.com
>
>
> -----Original Message-----
> From: Dindy Paul
> [mailto:oracledba-ezmlmshield-x88365709.[Email address protected]
> Sent: Thursday, September 06, 2007 9:50 AM
> To: LazyDBA Discussion
> Subject: RE: Count function
>
> There is no difference.
> There was a discussion recently where it seemed as if using count(rowid)
was
> a bit faster than other methods.
> Paul D.
>
> -----Original Message-----
> From: Ajay Kumar Jindal
> [mailto:oracledba-ezmlmshield-x7807713.[Email address protected]
> Sent: Thursday, September 06, 2007 7:10 AM
> To: LazyDBA Discussion
> Subject: Count function
>
> Dear All,
>
> can anybody tell me what is the difference betweeen count(*) and
> count(2)
>
>
> Regards,
> Ajay Jindal
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba
> job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
> unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information or otherwise protected by law. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply e-mail and destroy
> all copies of the original message.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba
> job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
> unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


Oracle LazyDBA home page