Re: count(*) very very slow with few records ?

From: Barry Evans <barry_at_promaxis.com>
Date: 2000/05/04
Message-ID: <3qjQ4.477$714.10619@news.magma.ca>#1/1

My guees is Orcale is using the pk index to count records. When a record is deleted space in the index is not freed up and the index can grow quite large. Do a create or replace for you index and then redo the count if it is speeds up then this was the problem.

Barry Evans
linux <linux_at_anonymous.to> wrote in message news:JzgQ4.477$S14.2415688_at_nnrp1.proxad.net...
> Hello,
>
> Any idea for that :
> count(*) very very slow with few records ?!
> The table contains one CLOB column and have frequently "insert/delete"
> operations
>
> Thanks
>
>
>
>
Received on Thu May 04 2000 - 00:00:00 CDT