Re: Defragmenting table

Not sure what the hang up is, but try doing a count(*) with a hint to use the primary key index. Primary Keys cannot be null so the count should be accurate and you will have to read only the index rather than the table.

I would think your count(*) would use the index anyway, but perhaps the statistics are old?

Dave A

"FGuelfucci" <fguelfucci_at_goalgroup.co.uk> wrote in message news:8psl8q$3eq$1_at_nnrp1.deja.com...
> Hi there,
> I hope that someone could help me with a little problem.
> I often have to do a query on a table, +/-30000 rows, but for some
> reason the system takes between 10 to 40 secs to return from the select
> count(*), statement, (other tables are 5 times the size and 3 times
> faster).
> There are 2 indexes and 2 primary keys. The size of the table would
> indicate that it should be very quick.
> For the purpose of the application I have to do a select count(*) often
> as the exact number of rows varies from time to time, does any one know
> a better way of doing it or a SQL statement that would defrag the table.
> Any help would be great, (and would make me look great at work).
> Thanks for all the help you can give.
> Florent.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 15 2000 - 06:07:08 CDT