Defragmenting table

From: FGuelfucci <fguelfucci_at_goalgroup.co.uk>
Date: Fri, 15 Sep 2000 08:05:51 GMT
Message-ID: <8psl8q$3eq$1@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 - 03:05:51 CDT