Re: rebuild indexes

From: Bob Fazio <bob_fazio_at_hotmail.com.no.spam>
Date: Thu, 09 Sep 1999 04:42:06 GMT
Message-ID: <yUGB3.3841$E46.10367@news.rdc1.pa.home.com>

A rebuild is on an index is really only necessary if you do a lot of deletes, not inserts.

Analysis is necessary. This is used to aid the optimizer in making decisions
based upon the cardinality of the index.

Anurag Minocha <anurag_at_synergy-infotech.com> wrote in message news:37D73194.C364A755_at_synergy-infotech.com...
> Hi,
> I have a table with an index on it. Hundreds of records are added every
> day in this table.
> Do i have to rebuild the index frequently or do i have to analyse the
> index frequently to improve my performance.
> Can somebody please tell me why do we need to analyse indexes
>
> Thanks
> Anurag
>
> also reply at
> anurag_at_synergy-infotech.com
>
Received on Wed Sep 08 1999 - 23:42:06 CDT