if the table are analyzed frequently, num_rows in user_tables may be used,
may not be accurate.


Alok Kumar

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] Thursday, January 31, 2002 3:22 PM
To: LazyDBA.com Discussion
Subject: counting rows quickly


Is there a faster way to get the number of rows in a table besides
count(*) or rowid?

In SQLSERVER there is a system stored procedure that will do this.

Kevin J. Sexton
Sr. Database Administrator

AdvanceMed Corporation
11710 Plaza America Drive
Reston, VA 20190-6017
http://www.eadvancemed.com



--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page