Re: number of rows in a table

I'm taking a guess here but that column may be filled in after the table has been analysed.

M

In article <7sveac$o1c$1_at_nnrp1.deja.com>,   Owais Anjum <owais_anjum_at_my-deja.com> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 01 1999 - 03:52:03 CDT