Re: "Defrag" a table

From: Frederik Hansen <roirex_at_post1.tele.dk>
Date: Fri, 24 Sep 1999 10:53:07 +0200
Message-ID: <37EB3BF3.D3D50003@post1.tele.dk>

Hi Kevin

> again when deleted. Secondly a 'whole pile' of rows allocated towards the
> end of the table and then freed up again when deleted. Thirdly as a result

I have done it this way..

> My understanding of how indexes building work could mean that there are

It a very little table, so no other than an index due to the primary key is used.

> Another factor might be when during this process you analyzed statistics for

Nope, I haven't done any analyzed statistics.

> or Truncate it (Truncate removes ALL rows, so beware). Either will reset the
> HWM.
How do I reset the HWM? (I will not truncate the table)

Frederik Hansen Received on Fri Sep 24 1999 - 03:53:07 CDT