RE: Coalescing Indxes on a regular basis

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 10 Apr 2007 12:34:03 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF270BDF9985@AABO-EXCHANGE02.bos.il.pqe>

In general, it should not be necessary to rebuild or coalesce indexes regularly, though there are a couple of exceptions.

See Richard Foote's paper for the whole story: http://www.miracleas.dk/images/upload/Docs/Richard%20Foote.pdf

-Mark

--

Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA

"There are 10 types of people in the world: Those who understand binary, and those who don't."

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fmhabash_at_gmail.com Sent: Tuesday, April 10, 2007 11:40 AM
To: oracle-l
Subject: Coalescing Indxes on a regular basis

Does any implement this type of maintenance on indexes regularly? Theoretically, this should be good practice on tables that witness large number of updates or deletes.
For those who do not, can you please explain why?
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 10 2007 - 11:34:03 CDT