Re: Number of hits

Hi,

select count(pk) from Huge_table
where pk > ' '

Young-chul,Jun schrieb:
>
> 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

--

Regards

Matthias Gresz :-)

--
Matthias.Gresz_at_Privat.Post.DE

          /|
         / |        
        /| |\
       /||  |\
      / O    |\         
     |        |\ Galopping Horse beats Running Man.
    /          |\
   /      /     |\
  /    __/|      |\
  \°   /  |       |\
   \/_/   |        |\