Re: index fragmentation

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Sat, 16 Sep 2000 17:12:49 GMT
Message-ID: <8q09m4$3md$1@nnrp1.deja.com>

Hi.

Use ANALYZE INDEX <your_index> VALIDATE STRUCTURE command and afterward SELECT * FROM INDEX_STAT view.
Look for deleted/leaf_rows ratio.

HTH. Michael.

In article <yszw5.1401$l35.28112_at_iad-read.news.verio.net>, "Legend" <legend_at_spacelab.net> wrote:
> Could someone tell me how to find out index fragmentation in a
database? How
> bad is bad for index?
>
> regards,
>
> benny
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Sep 16 2000 - 12:12:49 CDT