Re: reorder table data

vinita bansal wrote:
> Hi,
>
> I have a 40GB database with a few tables containing approx 10 million
> rows.  Most of the data in these tables is inactive and there is only a
> few rows which get used for our benchmark run each day. We cannot delete
> the inactive data since it might be required for a particular run some
> day while it is active data that is used mostly.

Is there some pattern to which data is being accessed. For example, in
an accounts system it might be rows with paid=false.

--
   Richard Huxton
   Archonet Ltd