Re: Coalescing Indxes on a regular basis

No I don't. and until I can firmly establish that a specific problem that I am facing is _due_ to an un-coalesced index, I would hesitate to do it.

Can you show me how to figure that out? I am curious.

rjamya

On 4/10/07, fmhabash_at_gmail.com <fmhabash_at_gmail.com> wrote:
>
> Does any implement this type of maintenance on indexes regularly?
> Theoretically, this should be good practice on tables that witness large
> number of updates or deletes.
> For those who do not, can you please explain why?
>

--
http://www.freelists.org/webpage/oracle-l