stale – ANBOB

sql script: 找出stale statistics的对象

2022-11-292012-04-09 by weejar zhang

Using the code below one can find the tables/indexes that have stale statistics in a schema, when options=>’GATHER AUTO’ is used oracle gathers statistics analyzes the tables/indexes that have stale statistics.