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

Re: COUNT(*) takes forever

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Thu, 04 Feb 1999 21:53:55 +0000
Message-ID: <36BA16F3.E057152C@rdbms.freeserve.co.uk> 





Richard



Do you have a copy of the explain plan ?



Chris



Richard Murphy wrote:


> 


> 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 - 15:53:55 CST












Original text of this message













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