Re: Number of hits

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Wed, 16 Sep 1998 22:43:33 -0700
Message-ID: <6tq79c$ce2@sjx-ixn2.ix.netcom.com>

I will definitely NOT recommend you to analyze a 20 millions rows table. It may take forever to do so!

Winnie
Certified DBA

È²»ó±¸ wrote in message <36006640.EB5ED343_at_ns.maninet.co.kr>...
>If you analyzed the table, you can use follow SQL:
>
> select table_name, num_rows from user_tables;
>
>Good luck.
>
>Herve wrote:
>
>> Hi,
>>
>> I've got a very huge table on Oracle (at least 20 million rows.
>> How to find out very quickly the number of hits ?
>> The Select count(*) statement is quite slow.
>>
>> Herve Meftah
>
Received on Thu Sep 17 1998 - 00:43:33 CDT