RE: Coalescing Indxes on a regular basis
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <fmhabash@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Apr 2007 12:34:03 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of fmhabash@xxxxxxxxx
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?
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
