Hi,
As such there is no difference in functioning but if you see performance
wise count(1) is more faster.


Lav Pandit | System Analyst | GIOS


-----Original Message-----
From: Ajay Kumar Jindal
[mailto:oracledba-ezmlmshield-x7807713.[Email address protected]
Sent: Thursday, September 06, 2007 4:40 PM
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



Oracle LazyDBA home page