Re: How to get NUM_ROWS?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 12 Apr 1999 10:37:19 +0900
Message-ID: <37115C5F.36F3@bhp.com.au>

EBR wrote:
>
> Hi,
>
> I'm using ALL_TABLES and the column NUM_ROWS is always empty. Using
> SELECT COUNT(ROWID) FROM table is unreasonable for very large tables.
> What can I do to get NUM_ROWS instantly?
>
> Thanks,
>
> EBR
> ** Please remove the primes to get my real e-mail

You can anaylze the table (cf: analyze command), but after this point references to NUM_ROWS will be an approximation, not an exact count since people will preumabaly be adding/removing rows from the table

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Sun Apr 11 1999 - 20:37:19 CDT