Re: "Defrag" a table

From: Chetan Wagle <chetanw_at_yahoo.com>
Date: Fri, 24 Sep 1999 13:14:32 +0530
Message-ID: <7sfa26$59a$1@herald.ctp.com>

If u can, export and import the table to eliminate the fragmentation.

HTH,
Chetan

Frederik Hansen wrote in message <37EB1F82.86C2D19C_at_post1.tele.dk>...
>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 Fri Sep 24 1999 - 02:44:32 CDT