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


Oracle LazyDBA home page