Very true for 7 and 8! And absolutely correct, on theory.
But with 9i (release 4) and 10g database, did you see any real
difference?
Try to time your query on a simple table but large data. :-) hope you
have a watch that have more than a second hand.

-----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