Home » RDBMS Server » Performance Tuning » Which is faster count(*),count(1),count(rowid)
Which is faster count(*),count(1),count(rowid) [message #195416] Thu, 28 September 2006 08:48 Go to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
Which is faster count(*),count(1),count(rowid)

Explian all scenarios
Re: Which is faster count(*),count(1),count(rowid) [message #195421 is a reply to message #195416] Thu, 28 September 2006 09:05 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please Search the forum.
This question is been asked and answered too many times.
Previous Topic: DBLinks and performance Issues
Next Topic: i/o and disk planning
Goto Forum:
  


Current Time: Thu Aug 24 03:54:40 CDT 2017

Total time taken to generate the page: 0.01694 seconds