Re: rebuild index

From: <frank.van.bortel_at_gmail.com>
Date: 5 Oct 2006 06:23:00 -0700
Message-ID: <1160054580.030560.135510@h48g2000cwc.googlegroups.com>

Andrea schreef:

> frank.van.bortel_at_gmail.com wrote:
> > Andrea schreef:
> >
> > > Hi,
> > >
> > > someone can tell me if there are some warning if i want to rebuild all
> > > indexes of my database (oracle 10g), can i do it without any problem?
> > >
> > > thanks very much
> > >
> > > bye
> > > andrew
> >
> > There have been numerous discussion about the unnecessity of rebuilding
> > indexes - especially the "normal" (B-tree) indexes.
> >
> > What type of indexes do you want to rebuild, and -more importantly-
> > why?
>
> in effect i would like rebuild indexes for only increase the
> performance and for maintenance...
> my DB is for DML type of statements.
> So, may enough to run coalesce for all indexes .. right?
>
> thanks for your support

It will not help you in the long run, see this discussion: http://asktom.oracle.com/pls/ask/f?p=4950:8:16721210830380570237::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2913600659112 Received on Thu Oct 05 2006 - 08:23:00 CDT