Re: How many people here rebuid index regularly?

csn233_at_gmail.com wrote:

> Waste of time for majority of cases - yes. In a small number of cases
> where performance is critical and benefits are tangible, a good DBA
> should know which ones they are, and what he needs to do, and how
> often.

I agree with you. But I doubt you will find one DBA in 10,000 that can define the metric that will tell them when that is.

Hint: I would expect the correct answer might make reference to SYS_OP_LBID.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org