Dead slow count(*)
- From: Jordi Adame V <jordi@xxxxxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 29 Jan 2004 17:54:46 -0600
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
