Update stats

[former_member759680]

Update stats when run from DB13 only updates th statistics of tables that are listed in DB21 transaction.

I wanted to know whether the command - brconnect -u / -c -f stats -t all will update only the tables in DB21 or all tables in the system?

[former_member213438]

Guatam, for interest, why do you want to update stats for all tables? Is this a one-time exercise? You do know that in most SAP systems there are a huge number of tiny tables that won't benefit from updated stats.

[ashish_mishra2]

This command checks the table with statistics difference of 50% old vs. new, and update them if deviation is more than 50%.

This deviation is also configurable.

You can check the table statistics changes in DB20, if you see the deviation more than 50%, then itu2019s statistics is definitely going to be change in next update stats run.

Alternatively you can use below commands to update system statistics:

SAP note: 838725

From orasid:

brconnect -u / -c -f stats -t all -p 4

brconnect -u / -c -f stats -t oradict_stats

brconnect -u / -c -f stats -t system_stats

Cheers !!!

Ashish

[JPReyes]

-t all should include all tables.

Regards

Juan