Cost Based Optimizer Statistics

[Former Member]

Hi,

I just wanted to check on how to do this activity............

In my production system in R3........on HPUX 11.23 and Oracle DB 9i and ECC 5.0....

When I go to DB02.......Checks.......Date of Table Analysis......The output shows as below

Date of last analysis SAPDAT SYSTEM others

never analyzed 0 129 195

older one year 0 0 40,871

31 - 365 days 0 0 782

8 - 30 days 0 0 2,942

0 - 7 days 0 0 337

Total 0 129 45,127

How do I go about do the analysis for all the files so that there is an up-to-date status....

Thanks in advance.

Alfred

[Former Member]

You can force a creation of new statistics by using the "-f collect" force option:

brconnect -u / -c -f stats- t all -f collect

Nevertheless I usually would not recommend this because you can expect a high runtime of the statistics creation and "old" statistics are not "bad" statistics. Instead it is normal that statistics of static tables are months or years old. See note 825653 (7) for more information.

Regards

Martin