Re: why anlyze and rebuilding generate lot of redo ?

On Wed, 13 Mar 2002 11:01:56 +0100, kw <none_at_nowhere.where> wrote:

>Hi all
>
>8.1.7.0 on M$2000
>
>I use exec dbms_stats.gather_database_stats(); and then for every index
>in my app :
>"alter index XXX rebuild compute statistics;"
>
>After that there is 325 MB of new redo generated!!! (for both analyze
>and rebuilding indexes)
>
>Is there any way to avoid this huge redo generation ?
>Why ORACLE generate redo analyzing tables ?
>
>Thanks in advice
>Krzysztof Wlasiuk
>

Hi Krzysztof,  

alter index XXX rebuild compute statistics NOLOGGING;

will generate much less redo.

It is the rebuild that generates the huge redo, not the compute statistics.

Regards,

• Kenneth Koenraadt