Re: Ultimate Question: Oracle, MSSQL, Others vs MYSQL LIMIT Statement

From: Richard <stupiddickhead_at_postmaster.co.uk>
Date: Tue, 01 Oct 2002 19:11:23 +0100
Message-ID: <3D99E54B.6040002@postmaster.co.uk>

Christopher Browne wrote:
> Richard <stupiddickhead_at_postmaster.co.uk> wrote:
>

>>Serge Rielau wrote:
>>
>>>Online Reorg on the fly is very important to improve
>>>availability. The trend is to go towards reorg demons. I.e. your
>>>tables would be contantly reorg-ed in the background. It is
>>>therefore not acceptable to have any app hold a bookmark of some
>>>sort or other on a physical location.
>>
>>What is all this reorg stuff? What does it do? Why do you have to do
>>it? Do you have to do a lot of it?

>
>
> It is about reorganizing the physical structure of the database.
>
> You have to do it because over time the 'random' additions and
> deletions of data that take place lead to it being not optimally
> structured, which hurts performance and may even lead to the DBMS
> running out of "space" even though there is considerable space not
> being used.

So it doesn't re-use space from deletes? Received on Tue Oct 01 2002 - 13:11:23 CDT