Re: How to get NUM

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sun, 11 Apr 1999 21:37:58 +0200
Message-ID: <7eqtuq$jri$1@news1.skynet.be>

If there aren't any regular inserts or deletes, you could have the tables analysed, after which you could use num_rows. Oracle doesn't (ain't that a pity) keep num_rows updated. (Switch to Unify?)

A way to get them faster, if you have an index containing all rows (on columns that are not null) : eg. the column is numeric: select count(index_column) from table where index_column >= 0;

EBR <11eebr13_at_hotmail.com> heeft geschreven in bericht <37107d75.392221_at_news.newsguy.com>...
>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
Received on Sun Apr 11 1999 - 14:37:58 CDT

Re: How to get NUM_ROWS?