on 05-20-2009 10:38 AM
Hi all,
just a simple question: What do I have to do that auto_update_statistics do work?
I activated the auto_update_statistics for my DB a long time ago, expecting all the rest would run by itself. That means, no check if update statistics is nessesary or refresh statistics.
Now I just run a check update statistics and there are tons of tables need to be updated. How is this possible?
Best regards
Christian G
>
> Hi all,
>
> just a simple question: What do I have to do that auto_update_statistics do work?
>
> I activated the auto_update_statistics for my DB a long time ago, expecting all the rest would run by itself. That means, no check if update statistics is nessesary or refresh statistics.
>
> Now I just run a check update statistics and there are tons of tables need to be updated. How is this possible?
Hi Christian,
how did you check whether the statistics needed an update?
The automatic stats update is based on the system table [SYSUPDSTATWANTED
|http://maxdb.sap.com/doc/7_7/45/2d525dd79f3446e10000000a155369/content.htm].
Whenever the optimizer realizes that the statistics aren't fitting anymore to what it actually finds in the tables during joins (and joins only!), it enters the table name to this system table.
The automatic statistics update is then triggered to gather new stats on the tables in the system table.
Therefore this is a reactive process and therefore not what we want to have in a SAP system.
That is basically the reason for why this feature is not supported to be used with SAP systems.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
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.