Wouldn't it make sense to simply use dbms_stats?
I think GATHER_SCHEMA_STATS with the parameter OPTIONS set to GATHER AUTO, GATHER STALE or GATHER EMPTY would be a nicer solution.
|
Results 1 to 10 of 11
Thread: auto analyze partition !!Threaded View
|
Click Here to Expand Forum to Full Width |