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
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: 7062
Registered: December 2001
Senior Member
No difference. It's the same.

MHE
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Diff between count(0) and count(*)
./fa/456/0/

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


Current Time: Fri Dec 09 08:08:21 CST 2016

Total time taken to generate the page: 0.07934 seconds