Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Finding total Rows without count() ?
I think if you run analyze table......compute statitistics then a value will
be placed in dba_tables.num_rows column.
Which of course will only give you the number of rows at the point in time that analyze table was run but it sure is fast if your only chasing ball-park numbers.
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 Tue Dec 14 1999 - 21:09:49 CST