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

It looks like your table's high water mark is set much higher than the actual number of rows in your table. Most DBMSs keep track of the maximum number of records (or blocks) ever held by a table, this number is called the high water mark. Therefore if you insert a lot of values into a table then delete them then the DBMS will still think that the table is large and therefore must do additional operations (I'm not quite sure what they are).

I'm not sure if your deletions remove all rows, but if they do then use truncate. This will reset the high water mark. Other than that I can only suggest that you rebuild your table when a large number of deletions occur.

-Peter

On Thu, 4 May 2000, linux wrote:

> 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