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 -> Number of hits

Number of hits

From: Herve <hmeftah_at_capgemini.co.uk>
Date: Wed, 16 Sep 1998 09:38:14 +0100
Message-ID: <35FF78F5.10B5@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 - 03:38:14 CDT












Original text of this message













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