Learning Bee,

Thanks for the advice but your script is doing the samething I'm doing. Except with the rebuilding the indexes. (at least that's how I'm reading it. Also, Oracle now days is recommending to use the dbms_stats package instead of the utility one. Something about better global stats gathering.

I'm just using the dbms_stats.gather_schema_stats to analyze the whole schema. What's nice is that it only takes about 3 hours to compute stats for SDE. Now ITVDBA that's a different story. 34mil rows in one table *whistles*..