Re: want to stop analyze once the database is stable

In my experience, if you need STABLE environment - use option (b) and this is our preferred option. In fact, we prefer to have statistic change to be part of our software development cycle (with some exceptions as mentioned already).

2006/4/2, Wolfgang Breitling <breitliw_at_centrexcc.com>:
>
> I HAVE to reply to this ( and you know it and maybe even counted on it :-)
> ).
> The way I see it, you have two choices:
>
> a) Do the daily analyze and then deal with the problems it causes
> b) NOT do the daily analyze and then deal with the problems IT causes
>
>

--
Best regards,
Alex Gorbachev

--
http://www.freelists.org/webpage/oracle-l