Re: Count(*) is very slow

From: Andreas Kyritz <AKyritz_at_easy-soft-dresden.de>
Date: Tue, 20 Oct 1998 16:51:04 +0200
Message-ID: <70i89i$bai$1@news.ipf.net>

Hi Jack,

Jack Carter schrieb in Nachricht <70i6g5$24k$1_at_excalibur.flash.net>...
>Just do a ... Select count (primary key column) from ? instead of Select
>count(*) and it will use the index.
>

I've tried this, before posting the first message to the NG. But it takes exactly the same time (35 seconds).
The only think I can imagine is, that a primary key with varchar2(9) type is a problem.

--
Andreas Kyritz
AKyritz_at_easy-soft-dresden.de Received on Tue Oct 20 1998 - 09:51:04 CDT