Oh not this again.....................

-----Original Message-----
From: Somasekhar Bangalore
[mailto:oracledba-ezmlmshield-x99530394.[Email address protected]
Sent: Wednesday, June 02, 2004 8:49 AM
To: LazyDBA.com Discussion
Subject: RE: Just out of curiosity

Of course , it matters,

select count(*) ---it takes all the columns into account.

select count(1) ---this one takes the first column..


also select count(1) is faster compared to the count(*).

regards
som



-----Original Message-----
From: Edwin Uy
[mailto:oracledba-ezmlmshield-x93770188.[Email address protected]
Sent: Wednesday, June 02, 2004 4:35 PM
To: LazyDBA.com Discussion
Subject: Just out of curiosity


Hi all,



select count(*) or select count(1) . does it really matter . ???



Cheers,

EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page