Re: Fragmentation and TRUNCATE vs. DROP

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:40599632$0$6552$ed9e5944_at_reading.news.pipex.net...
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> news:40598db9$0$3956$afc38c87_at_news.optusnet.com.au...
> > Any indication in the text as to when this particular gem was written?
> > Because it's pretty ancient advice these days. The whole idea of
> controlling
> > fragmentation by creating fewer extents went out the window with the
> > introduction of uniform sized locally managed tablespace. With US-LMTs,
> > every extent is the same size for all segments within a given
tablespace,
> > and therefore fragmentation can never, ever happen. Doesn't matter how
> many
> > extents you've got.
> > The advice would therefore appear to be coming from the dark ages of
> version
> > 8.0 or before.
>
> Originally written in 1999, last updated in 2001 but doesn't so far as I
can
> see cover LMT.

Cheers Niall. I guessed as much.
Regards
HJR Received on Thu Mar 18 2004 - 06:33:14 CST