Here we go again.
-----Original Message-----
From: Somasekhar Bangalore
[mailto:oracledba-ezmlmshield-x99530394.[Email address protected]
Sent: Wednesday, June 02, 2004 7: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
This message is confidential and intended only for the individual
named. If you are not that individual, do not disseminate,
distribute or copy this e-mail. If you feel you have received this
message in error, please contact the sender immediately and
delete this message. Information transmitted by e-mail is not
secure and may be intercepted by a third party. You may submit
time-sensitive, action-oriented messages or confidential
information such as social security numbers, account numbers,
credit card numbers through http://www.southtrust.com online
applications and customer service forms. SouthTrust accepts no
liability for damage caused by any virus transmitted by this e-mail.
Oracle LazyDBA home page