Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index Maintenance: Another Oracle Gem

Re: Index Maintenance: Another Oracle Gem

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 17 Oct 2006 18:28:42 GMT
Message-ID: <J7ALzv.783@igsrsparc2.er.usgs.gov>


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

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Tue Oct 17 2006 - 13:28:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US