Re: rebuild index

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 Received on Thu Oct 05 2006 - 05:56:49 CDT