Re: When should one rebuild an index?

From: Jonathan Lewis <>
Date: Tue, 30 Dec 2008 23:09:05 -0000
Message-ID: <>

"Mladen Gogala" <> wrote in message news:gjdbrc$ivs$
> On Mon, 29 Dec 2008 20:43:52 -0600, Bob Jones wrote:
>> Yes, it is very application dependent. Index rebuilds often yield
>> different results in different situations.
> And index rebuilds can hit a bug and yield "invalid rowid" error, as
> reported by J. Lewis.

It's not so much a bug as a design defect that could be quite hard to code around given it's connection with cross-DDL read-consistency - see for anyone who hasn't seen the problem before.

And there are cases where indexes fairly obviously need some sort of housekeeping - and often you don't need to run any query against them to know that they are going to run into trouble, e.g.


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ
Received on Tue Dec 30 2008 - 17:09:05 CST

Original text of this message