Can we discuss the parallel aspect a little?

I haven't played with the analyze-type procs from the package yet because my own ANALYZE procs work just fine for me so far

I have my procs set up so they can be broken up into as many calls as you want that run at the same time. So, you can run 5 jobs, each one pulling from the same list of tables (but not overlapping).

So, I can be, in this example, analyzing 5 indexes at the exact same time. Since, from my limited understanding, DBMS_STATS will not analyze an index in parallel, I don't see the proc that analyzes the whole schema as sufficient to replace my existing process. Although I could replace my ANALYZE TABLE calls with the the corresponding package calls, of course.

Thoughts?

- Chris