Re: Fragmentation

From: James Belton <rsitest_at_freenetname.co.uk>
Date: 2000/07/28
Message-ID: <8lsban$sfd$1@gxsn.com>#1/1

A good way to identify fragmentation is to see how many extents each table or object has. In general, The greater the number of extents, the more fragmented the table.

There's a script to detect fragmentation by number of extents on my web site at http://www.jamesbelton.co.uk

James

<thiko_at_my-deja.com> wrote in message news:8lrkbr$52m$1_at_nnrp1.deja.com...
> Hi
>
> Does anyone know how to identify fragmentation in tables without using
> the analyze or compute statistics sql? Is there any SQL for this?
>
> Many Thanks
>
> Thiko!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 28 2000 - 00:00:00 CDT