Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table fragment and index rebuild time
On Jan 25, 1:54 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
> On Jan 24, 4:14 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
> > Generally speaking regularly rebuilding tables and indexes is a waste
> > of both human and computer resources.
> > You would only need to rebuild something if that would *solve*
> > something.
> > Usually rebuilding doesn't resolve anything.
> > The futility of rebuilding indexes has been discussed here many times.
> > Please search the archives.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- Hide quoted text -- Show quoted text -Thanks a lot Sybrand.
> I will defiantly talk to my senior about it, because refreshing tables
> and rebuilding indexes is one of my regular work.
>
> Is it possible that you can give me any document no. on metalink. I am
> also searching for this ( particularly for tables and indexes), I would
> be very thankful if you please tell me that.- Hide quoted text -- Show quoted text -
Sybrand's response is consistent with the following two links: asktom.oracle.com is a great resource ("Rebuilding Indexes"): http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2913600659112
When Should You Rebuild an Index? (Jonathan Lewis) http://www.dbazine.com/oracle/or-articles/jlewis14
Metalink:
Note:1019722.6 ("TFSIFRAG.SQL provides information critical in
determining whether an index is a candidate for rebuilding." -- ???)
Note:100960.1 ("Rebuild the index if you have a lot of multiblock, or
chained rows, especially if you have recently rebuilt the table." --
???)
Note:375856.1 (Subject: Session Was Killed During The Rebuild Of Index
ORA-08104, Oracle Version: 9.2.0.6.0 to 11.0.0.0)
The AskTom article above is very helpful when trying to make sense of what is real, and what is imagined related to the topic of index rebuilds. The Metalink articles are a mixed bag of bug reports related to index rebuilds, and possibly some articles that need to be reviewed for accuracy. If you rebuild a table, you must rebuild the indexes for the table. If you issue ALTER TABLE MOVE, you must rebuild the indexes for the table.
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Thu Jan 25 2007 - 05:42:54 CST