Re: count of rows without select count(*) command...

From: Thomas Pall <tpall_at_bga.com>
Date: 14 Nov 98 23:48:05 GMT
Message-ID: <364e16b5.0@feed1.realtime.net>

If you have at least Oracle 7.3.3 and an index on one of the columns, you can have Oracle do a fast index scan to count the rows. See this URL: http://www.oramag.com/oracle/98-Jul/dba.html

BluesMan (ygrenet_at_club-internet.fr) wrote:
: Hi all,

: I have a table with near 150 M rows (12Go)...

: ...How could I know the number of rows without the ' select count(*) from
: table_name ' command ?
: for instance in the system tables...

: no statistics are launched...

: Thanks

: gotblues_at_mygale.org

-- Received on Sat Nov 14 1998 - 17:48:05 CST