How to find out if my index is optimal or scattered

From: sundar mahadevan <>
Date: Tue, 15 Sep 2009 11:45:25 -0400
Message-ID: <>

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:45:25 CDT

Original text of this message