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.

Oracle LazyDBA home page