number of rows in a table

From: Owais Anjum <owais_anjum_at_my-deja.com>
Date: Thu, 30 Sep 1999 10:33:28 GMT
Message-ID: <7sve9o$nqc$1@nnrp1.deja.com>

Hello

How do I find the number of rows in a table without using the count(*) query. I though that num_rows column in user_tables (and a few other views) is meant for the job, but when I query this view, it gives me a null for all tables.
With this behavior of num_rows, another question that comes into my mind is that what purpose does this column serve? I checked out the comments on this column which do say that it should return the number of rows in a table...

Confused
Owais

--
Owais Anjum
Senior Software Engineer
Kaps Computing, Pakistan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 05:33:28 CDT