Re: Analyzing indexes

Chuck wrote:

> I need to determine whether or not a couple of indexes need to be
> rebuilt. The problem is the indexes are quite large and on a 24x7 high
> volume database. If I try to run an "analyze validate structure" to
> gather the data I need to make that decision, it sets a lock on the
> table for about an hour which I can't afford to do. There is no slow
> time when I can do this and management has said before they're not going
> to spring for the partitioning option to break the indexes up into
> managable pieces. Is there some other way I can get the information
> needed to determine if an index needs to be rebuilt or not without
> setting a lock on the table? We are on Oracle 8.1.7.

How about using a statistical sample so that it completes in a few minutes?

Daniel Morgan Received on Tue Mar 11 2003 - 11:01:33 CST