Re: How to find out if my index is optimal or scattered
Date: Tue, 15 Sep 2009 11:56:13 -0400
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: http://www.orafaq.com/aggregator/sources/83 http://richardfoote.wordpress.com/category/index-rebuild/
Download Radiohead "In Rainbows" and read a few white papers.
On Tue, Sep 15, 2009 at 11:45 AM, sundar mahadevan
> 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.completestreets.org/faq.html http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 15 2009 - 10:56:13 CDT