Count(*) is very slow

From: Andreas Kyritz <AKyritz_at_easy-soft-dresden.de>
Date: Mon, 19 Oct 1998 14:23:20 +0200
Message-ID: <70fbcl$iu1$1@news.ipf.net>

Hallo,

does anybody know, why a

SELECT COUNT(*) FROM ATABLE
Statement is so slow ? On a table with 250.000 rows it takes more then 30 seconds ?!

The table has a primary key and the statistics were computed before executing this Statement.
It makes no difference using COUNT(PRIMARY_KEY) instead of COUNT(*). It seems that the server is doing a full-table-scan !

The server is a P200 with 96MB RAM, NT 4.0 SP3 and Oracle 8.0.5.

I've never seen a DBMS, which takes so much time for such a simple query.

Thanks for your help

--
Andreas Kyritz
AKyritz_at_easy-soft-dresden.de Received on Mon Oct 19 1998 - 07:23:20 CDT