Re: Finding total Rows without count() ?

How can this be faster than count(*)?

John Chiu wrote:

> (1) analyze table compute statistics
> (2) select num_rows from user_tables where table_name = 'your_table_name';
>
> HTH
>
> John Chiu
>
> Ken Sproule <kenmn_at_tds.net> wrote in message
> news:4trd5ssdlmn576ltqu3c6fsnln3qlufgob_at_4ax.com...
> > As always, thanks in advance for your help.
> >
> > I need a fast way to determine the total number of rows in a table. I
> > assume somewhere Oracle stores such information about its tables.
> > Where is it?
> >
> > The count() type syntaxes take much too long on tables of say 3+
> > million rows, so I'm looking for a fast way to accomplish it.
> >
> > Post answers to the group, as others might be interested also.
> >
> > Thanks,
> >
> > Ken Sproule
> > kenmn_at_tds.net
> >
> >
Received on Wed Dec 15 1999 - 00:13:53 CST