Re: When should one rebuild an index?
Date: Sat, 27 Dec 2008 15:30:02 +0100
"Robert Klemme" <shortcutter_at_googlemail.com> wrote in message
> On 27.12.2008 06:53, DA Morgan wrote:
>> If you truly want to know when to rebuild indexes read Richard's
>> comments. Read Jonathan Lewis' comments. And learn wield SYS_OP_LBID.
> Maybe we need something like BAARF for index rebuilding - or even rebrand
> BAARF to "battle against any rebuild flapdoodle".
>> Tom Kyte finally managed to make an impact with respect to bind
>> variables after carrying the torch for it seems like a decade.
> That's the bad side of internet not forgetting anything, especially if
> someone seems to be more proficient in search engine tuning of his pages
> than in dealing with Oracle on a scientific basis. :-)
>> anyone put this index rebuild nonsense into the rubbish bin where
>> it belongs? Please!
> But don't forget "PURGE DBA_RECYCLEBIN" afterwards! ;-)
I believe that there are still valid reasons for rebuilding indexes, for example when you remove a large amount of rows from a table, and you are sure that table will never grow to the same size anymore (failed batch load caused by programming errors etc.). Or not ? Received on Sat Dec 27 2008 - 08:30:02 CST