Brian Peasland wrote:
> DA Morgan wrote:
>> Have you ever wanted to rebuild all of the indexes in a list of
>> schemas? Indexes on a list of tables? A list of indexes or a list of
>> index components?
>>
>> If so:
>> www.psoug.org
>> click on Morgan's Library
>> click on DBMS_INDEX_UTL
>
> Daniel,
>
> I'm curious as to why you would build this utility. You, yourself, have
> been a proponent of *not* rebuilding indexes.
>
> I'm just wondering what your motivation was?!?!?! :)
>
> Cheers!
> Brian
Didn't build it ... found it as part of the default 10g installation.
I am definitely one that thinks most index rebuilds a waste of time. But
not all and it might be useful with global partition indexes.
--
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
Received on Tue Oct 17 2006 - 16:04:19 CDT
