Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dead slow count(*)

RE: Dead slow count(*)

From: Ashish Sahasrabudhe <asahasrabudhe_at_weightwatchers.com>
Date: Fri, 30 Jan 2004 13:33:25 -0500
Message-ID: <88CB7FA9E7225043893BE0702D04E41803512B1F@wwmbxny01.weightwatchers.com>


Check the high water mark of this table. May be there are lot of empty blocks
due to which count(*) is taking time.
-----Original Message-----

From: Jordi Adame V [mailto:jordi_at_inffinix.com] Sent: Thursday, January 29, 2004 6:55 PM To: Oracle-L_at_freelists.org
Subject: Dead slow count(*)

Hi!

I have this table with ~4,000,000 entries

When i do a SELECT COUNT(*) FROM TABLE_NAME

it takes 4 hours to give me the result, this is way too much

Im running Oracle 9.2.0.4.0 on RedHat AS 3

These are my first experiences with Oracle, so I have no clue how to fix this
query time... Any help would be nice

regards

Jordi



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Jan 30 2004 - 12:33:25 CST

Original text of this message

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