Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: number of rows in a table

Re: number of rows in a table

From: <rock_cogar_at_my-deja.com>
Date: Fri, 01 Oct 1999 12:47:27 GMT
Message-ID: <7t2ags$re0$1@nnrp1.deja.com>


To refresh dba_tables.num_rows,

analyze table scot.emp compute statistics;

In article <7t1sng$iit$1_at_nnrp1.deja.com>,   mgumbs_at_hotmail.com wrote:
> 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.
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US