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