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

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 3 Oct 2002 08:58:19 +1000
Message-ID: <vKKm9.45006$g9.128205@newsfeeds.bigpond.com>

Certainly doesn't!

(What, pray, are you thinking of... not the 'move' command, perchance?? And surely not the export-truncate-import shennanigans?)

The need to re-organise anything in Oracle is miniscule. Not saying the product is perfect, naturally, but PCTFREE/PCTUSED is a pretty efficient mechanism to ensure the re-use of "pages" vaccated by deletes.

Regards
HJR "Serge Rielau" <srielau_at_ca.ibm.com> wrote in message news:3D9B7435.8090704_at_ca.ibm.com...
> No one doubts that... Nonetheless a reorg utility exists :-)
>
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 UDB SQL Compiler Development
> IBM Software Lab, Toronto
>
> Try the DB2 UDB V8.1 beta at
> http://www-3.ibm.com/software/data/db2/
>
>
Received on Wed Oct 02 2002 - 17:58:19 CDT