Re: Number of hits

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 Wed Sep 16 1998 - 20:29:12 CDT