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 -> Re: Count(*) is very slow

Re: Count(*) is very slow

From: Stewart Burnett <Stewart_at_burnettms.nospam.demon.co.uk>
Date: Tue, 20 Oct 1998 15:38:02 +0100
Message-ID: <70i78e$qp1$1@hagen.cloud9.co.uk> 





The SQL standards state that count(*) must count the actual number of rows
and not use an Index - I believe.




Andreas Kyritz wrote in message <70i5pa$siv$1_at_news.ipf.net>...


>Hi Billy,


>


>Now my database is very well analyzed, but it makes no difference.


>Why isn't it possible to use the primary key for computing SELECT count(*)


>FROM ...?



>I think, most dbms doing it in this way.


>


>


>




Received on Tue Oct 20 1998 - 09:38:02 CDT












Original text of this message













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