Help.

From: <midascs_at_my-dejanews.com>
Date: Wed, 17 Jun 1998 13:37:10 GMT
Message-ID: <6m8gq6$8cn$1@nnrp1.dejanews.com>

Hi there

We have a largish table > 10 million rows in Oracle 7.3.

I'm trying to find a quick way of finding out how many rows are in the table.

Select count(*) from table is too slow...... Even when you get it to use indexes.... Also we don't want multiple users doing hefty full table/index scans.

Does anyone know if there is a way of querying the data dictionary to find an exact number of rows in a table. I aready know of dba_tables, but this is only maintained by the optimisers analyze function.

Or is there another way???????

Cheers
Mark

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 17 1998 - 08:37:10 CDT