You could use the num_rows column in dba_tables but that value only reflects
the number of rows present at the last time you analyzed the table. This can
be useful if the number of records does'nt change much or if you analyze
your tables very often.
--
---
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 - 07:28:02 CST
