on 06-17-2010 3:11 PM
Hi there,
I'm thinking about running the Oracle command "Analyse table" for all SAP tables.
Is there any way to schedule it by SAP?!
Has already anybody run it?!
Thanks in advance,
Dany Anderson
Through DB20, Can I run 100% of a table, right?!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes analyse command is for collecting CBO statistics.
Running update statistics will do this.
You can check tx code DB20 as well.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What version of oracle are you using?
As far as I know analyze command was used to update statistics... that can be done by running "Check and update optimizer statistics" in DB13 or using brtools.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.