Re: Finding total Rows without count() ?

From: John Chiu <johnymc_at_netscape.net>
Date: Tue, 14 Dec 1999 23:36:13 -0500
Message-ID: <8375lg$m6n$1@news2.tor.accglobal.net>

(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 Tue Dec 14 1999 - 22:36:13 CST