Re: why people delete statistics bore running statistics

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 23 Oct 2006 09:20:15 -0700
Message-ID: <1161620415.874309.260840@b28g2000cwb.googlegroups.com>

Actually, there could be a (valid?) reason ...
- could be used to regenerate all stats instead of just stale stats
(when auto is used)
- could be used to regenerate all stats, when statistics had been
previously 'locked'
- I don't know if this could impact how old statistics are moved to the
AWR
- there could also be an impact if the previous statistics were
generated with the Analyze statments

Also note that this could be very bad in 10g, as the statistic generation could be limited to a window that is too short for the entire schema, so it could cause some segments to not get new stats.

My 2cents Received on Mon Oct 23 2006 - 11:20:15 CDT