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: Dharambir Marwaha <dharambirmarwaha_at_hotmail.com>
Date: Thu, 04 Feb 1999 17:37:44 -0500
Message-ID: <36BA2138.607EF68D@hotmail.com> 





Try using select count(primary_key)  from your_table. That should save some
time.



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 - 16:37:44 CST












Original text of this message













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