Re: Finding total Rows without count() ?

From: Ton Haver <ton.haver_at_cover.nl>
Date: Wed, 15 Dec 1999 21:59:41 +0100
Message-ID: <3858013C.51FE6C90@cover.nl>

If I want an estimate of the count of one of our large tables, I'll look in the log of the export of last night. With a (unix) grep this gives me the number of last night within a second. Normaly I know the speed of the record growth during the day, so I know how valuable this estimate is.

Ton

Ken Sproule wrote:

> 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 - 14:59:41 CST