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

From: Mervyn at ifwdc.com <merv_at_ifwdc.com>
Date: 2000/05/09
Message-ID: <8f9u5k$1fn8$2@brimstone.medianet.ie>#1/1

Hi,

Have a look at the table layout.

select * from user_segments
where segment_name = 'your table name'

Your looking for a large number of extents, or a huge size.

you could try selecting count(<any indexed column>) from table if the column is a unique indexed column? Perhaps then it will only read an index and not a whole table?

Merv.

linux <linux_at_anonymous.to> wrote in message news:fyQR4.71$5B3.209008_at_nnrp2.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 Tue May 09 2000 - 00:00:00 CDT