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

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:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2290062993260

or spend some time on Ricard Foote's site: http://www.orafaq.com/aggregator/sources/83 http://richardfoote.wordpress.com/category/index-rebuild/

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

hth.

Paul

On Tue, Sep 15, 2009 at 11:45 AM, sundar mahadevan <sundarmahadevan82_at_gmail.com> 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.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
http://www.completestreets.org/faq.html
http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
--
http://www.freelists.org/webpage/oracle-l