Re: When should one rebuild an index?

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 30 Dec 2008 14:38:18 +0000 (UTC)
Message-ID: <gjdboq$ivs$9@solani.org>


On Sun, 28 Dec 2008 18:08:46 -0600, Bob Jones wrote:

> Index structure and space usage are meaningless in determining index
> rebuild? So in your opinion what is meaningful?

Nothing. Indexes do not need to be rebuilt on regular basis, period. Please, read this:
http://www.oracle.com/global/nl/education/specials/pdfs/0806_richard.pdf

-- 
Mladen Gogala
http://mgogala.freehostia.com
Received on Tue Dec 30 2008 - 08:38:18 CST

Original text of this message