Re: "Defrag" a table

From: Angus Liu <angusliu_at_gti.com.hk>
Date: Mon, 27 Sep 1999 19:04:28 +0800
Message-ID: <37EF4F3C.436458A9@gti.com.hk>

Is seems that there is no way to "defrag" a table, the only solution is export and import table / database !!

Angus

Frederik Hansen wrote:

> Hi
>
> Is there anyway to "defrag" a table? I have a table which normaly have
> tree rows, some how someone (for test perpose) inserted 1023115 rows. I
> now after I have deleted all the uwanted rows it take from 3-7 sec. to
> do a "Select *" on the tree rows...
>
> So how do I make it go fast again??
>
> Frederik Hansen
Received on Mon Sep 27 1999 - 06:04:28 CDT