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

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.

-- 
(reverse (concatenate 'string "ac.notelrac.teneerf@" "454aa"))
http://cbbrowne.com/info/finances.html
"MS  apparently now  has a  team dedicated  to tracking  problems with
Linux  and publicizing them.   I guess  eventually they'll  figure out
this back fires... ;)" -- William Burrow <aa126_at_DELETE.fan.nb.ca>