Re: How to find out if my index is optimal or scattered

From: Paul Drake <>
Date: Tue, 15 Sep 2009 11:56:13 -0400
Message-ID: <>


How many times have you rebuilt it?

C'mon. Everyone deserves a laugh now and then.

The column [dba user all] _indexes.clustering_factor has some info for you. Check that with blevel, num_rows, leaf_blocks ...

or read this thread:

or spend some time on Ricard Foote's site:

Download Radiohead "In Rainbows" and read a few white papers.



On Tue, Sep 15, 2009 at 11:45 AM, sundar mahadevan <> wrote:
> Hi All,
> I would like to know if there is a way to find out if my index is
> scattered. Lets say I have a table and the table's primary key(or the
> indexed key) is inserted/updated and deleted regularly. Do I find
> these details from user_indexes or are there any other tables that
> would give me the required information to find if the index is
> scattered? Any help is appreciated. Thanks in advance.
> --

Received on Tue Sep 15 2009 - 10:56:13 CDT

Original text of this message