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 -> COUNT(*) takes forever

COUNT(*) takes forever

From: Richard Murphy <rmurphy_at_lbpc.com>
Date: Thu, 04 Feb 1999 20:16:21 GMT
Message-ID: <36BA003C.85848E7D@lbpc.com> 





Anyone now what would cause a simple select count(*) to take a very long
time (hours) on a table of 26 million rows.  Other processes on the
database do not seem to be a problem.  This is on Oracle 8 on VMS.



Thanks, R.

Received on Thu Feb 04 1999 - 14:16:21 CST












Original text of this message













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