Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to know when an index needs rebuild ?
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3F7411E0.4B2B_at_yahoo.com>...
> Mark wrote:
> >
> > Hi all dba users,
> > I'd like to know if there's some good sql script / indicator to detect if an
> > index need to be rebuilt.
> > Thanks a lot
> > Mark
>
> Don't.
>
> Or use coalesce
>
> hth
> connor
isnt there something to look for in index_stats? I have found that if we do alot of deletes and rebuild it there is a big speed increase(yes I know creating the table or doing a 'move' is import too). Received on Fri Sep 26 2003 - 11:58:16 CDT