-
I have a owner with 400 tables, and about 800 indexes.
It takes like 3 hours to execute a dbms_utility.analyze_shema(owner, compute);
But if i do a script with:
analyze table table_name1 compute statistics;
analyze table table_name2... etc...
It takes like 1 hour.
Question: Does both do exactly the same thing, or analyze_schema does something more?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|