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: <mgogala_at_yahoo.com>
Date: Thu, 04 Feb 1999 22:01:20 GMT
Message-ID: <79d5b8$bco$1@nnrp1.dejanews.com>


In article <36BA003C.85848E7D_at_lbpc.com>,   Richard Murphy <rmurphy_at_lbpc.com> 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.
>
>

It may be a consequence of previous manipulations, so that HWM is far below the real end of data. My suggestion is to export the table, truncate it, re-imort and then retry.
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 16:01:20 CST

Original text of this message

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