Re: How to know when an index needs rebuild ?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 27 Sep 2003 09:00:29 +1000
Message-ID: <3f74c5c5$0$15134$afc38c87@news.optusnet.com.au>

Ryan Gaffuri wrote:

> 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).

Try reading other posts in the thread. I answered you about index_stats.

But when Connor tells you 'don't', that's something worth listening to.

Regards
HJR Received on Fri Sep 26 2003 - 18:00:29 CDT