本文探讨了在特定情况下如何处理Oracle数据库中的统计信息，包括手工调整、恢复及避免不必要的重新收集等场景，对于小规模但逐渐增长的数据表尤为重要。
Perhaps these tables have lots of hand-crafted changes done with DBMS_STATS.SET_xxx_STATS procedures.
Perhaps gathering is a time-consuming activity that you know isn’t necessary or will not be necessary for some time.
Perhaps you have restored statistics and you know that re-gathering will cause problems.
Perhaps the statistics for a small but growing table have been imported from a test system and reflect future large volumes and you want to make sure that these imported
statistics are not overwritten by statistics that reflect the current low row count
扫一扫
1162
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
