RE: Coalescing Indxes on a regular basis

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 10 Apr 2007 12:28:18 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08CFC@EXCNYSM0A1AJ.nysemail.nyenet>

Fmhabash (it would be nice if you signed your letters),

Theoretically, I will be married to Angelina. But that ain't gonna happen either.

I do not do this because it simply becomes make-work and possibly require down-time. And there is no evidence that there is any benefit at all.

So this becomes just another urban legend "good practice" that is simply a myth.

Hope this helps

Tom

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----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:28:18 CDT