Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> count of rows without select count(*) command...

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

From: BluesMan <ygrenet_at_club-internet.fr>
Date: Sat, 14 Nov 1998 04:24:40 +0100
Message-ID: <72it24$mfk$1@front1.grolier.fr>


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 Fri Nov 13 1998 - 21:24:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US