Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed.vmunix.org!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail
Date: Sat, 01 May 2004 01:07:13 +1000
From: "Howard J. Rogers" <hjr@dizwell.com>
User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Index management
References: <c86ce4f.0404300648.63277bc8@posting.google.com>
In-Reply-To: <c86ce4f.0404300648.63277bc8@posting.google.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 11
Message-ID: <40926b99$0$440$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: 203.164.5.182
X-Trace: 1083337626  440 203.164.5.182
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260523

DiggidyMack69 wrote:
> Are there supplied scripts, packages, or procedures that will find and
> rebuild existing index's?  What I am really looking for is a script to
> be run to rebuild fragmented index's as needed.

Trust me, that's the last thing you want.

Leave indexes alone. They cope quite nicely on their own.

Regards
HJR