Home » SQL & PL/SQL » SQL & PL/SQL » count(*) or count(1)
count(*) or count(1) [message #216725] Tue, 30 January 2007 03:01 Go to next message
meeta
Messages: 28
Registered: January 2000
Junior Member
out of count(*) and count(1),whose speed of execution will be faster and why????
can anyone tell me

Report message to a moderator

Re: count(*) or count(1) [message #216728 is a reply to message #216725] Tue, 30 January 2007 03:06 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
No difference. It's the same.

MHE

Report message to a moderator

Re: count(*) or count(1) [message #216729 is a reply to message #216725] Tue, 30 January 2007 03:09 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Diff between count(0) and count(*)
/forum/fa/456/0/

By
Vamsi

Report message to a moderator

Previous Topic: Calculate the count of Concurrent connections to a website for every minute
Next Topic: concatenating msg and statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 07:06:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.