Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed1.sbs.de!nntp.fujitsu-siemens.com!not-for-mail From: "Volker Hetzer" Newsgroups: comp.databases.oracle.server Subject: Re: Index maintenance... Date: Wed, 5 May 2004 13:06:40 +0200 Organization: Fujitsu Siemens Computers GmbH Lines: 19 Message-ID: References: <4098c22d$0$6018$afc38c87@news.optusnet.com.au> NNTP-Posting-Host: abg0752c.abg.fsc.net Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Trace: nntp.fujitsu-siemens.com 1083755200 21586 141.29.58.180 (5 May 2004 11:06:40 GMT) X-Complaints-To: abuse@sbs.de NNTP-Posting-Date: Wed, 5 May 2004 11:06:40 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260826 "Howard J. Rogers" schrieb im Newsbeitrag news:4098c22d$0$6018$afc38c87@news.optusnet.com.au... > It is always possible you've got a rogue index and that a rebuild might > result in a measurable performance boost. It is, though, rather > unlikely. In general, indexes don't need rebuilding, and doing so > doesn't improve performance. In general, that is. Yup. The guy (and we too) are unusual in that we do lots of inserts, deletes and inserts again because we are debugging an app that uses the db. > Without benchmarks to prove the point, I would think that wishful > thinking is what is actually behind it. Ok. > > Without benchmarks, the assertion by your consultant is meaningless. We'll check it out on out environment. Lots of Thanks! Volker