Re: In search of script to generate analyze command

Patrick Burns wrote:

> I am in search of a generic script that will run everyday in our
> nightly cycle and write to an sql file an analyze statement if a
> certain percentage of the rows have changed, 20%. Then every weekend
> use dbms_stats to analyze the tables and indexes.
>
> I have seen these types of things in this group but can't seem to find
> one around.

Why a strong desire to use the wrong tool and reinvent the wheel.

Go to http://tahiti.oracle.com and look up DBMS_STATS.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)