Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.cc.ukans.edu!newsxfer.eecs.umich.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail
Date: Wed, 05 May 2004 20:28:17 +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 maintenance...
References: <c7abns$lm2$1@nntp.fujitsu-siemens.com> <4098b914$0$20516$ed9e5944@reading.news.pipex.net>
In-Reply-To: <4098b914$0$20516$ed9e5944@reading.news.pipex.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 26
Message-ID: <4098c1b7$0$6018$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: 203.164.4.221
X-Trace: 1083752887  6018 203.164.4.221
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260819

Niall Litchfield wrote:

> "Volker Hetzer" <volker.hetzer@ieee.org> wrote in message
> news:c7abns$lm2$1@nntp.fujitsu-siemens.com...
> 
>>Hi!
>>We've got a consultant (for a canned app) here who just hinted at a
> 
> possible performance improvement
> 
>>if one recreates the indexes after a big load.
>>He said he noticed an improvement but didn't run any benchmarks. He used
> 
> 8.1.something and 9.0.something.
> 
>>We are using 9.2.0.4.
>>So, what's behind this?
>>Does this apply to us too?
> 
> 
> checkout www.dbzine.com/jlewis14.shtml 

Is that the right address??

Regards
HJR