Re: Number of hits

From: Young-chul,Jun <ycjun_at_hotmail.com>
Date: Wed, 16 Sep 1998 19:20:06 +0900
Message-ID: <6to2ol$q47$1@news.kren.nm.kr>

It will be better fast using INDEX.

If there is index on huge table, Use below sql statement.

select count(*) from Huge_table
where index_col > ' '

Bye..

Herve ÀÌ(°¡) <35FF78F5.10B5_at_yahoo.com> ¸Þ½ÃÁö¿¡¼ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
>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 - 05:20:06 CDT