Update Statistics

[Former Member]

Hi All,

How can I list the tables those statistics are not updated or thresholds might be too loose after running regular statistics job in DB13?

u2022 Is it necessary to check or we can leave it by assuming that the regular u201Cupdate statisticu201D job will do it correctly

u2022 If it is necessary, what are the criteria?

With Regards.

[Former Member]

Hi,

Here you can find the list.

DB02->Checks->Dates of table Analysis

Here you will get the list, click on the list and you will find tables,with sample size etc

Use DB20 to update statistics with new sample size.

You can also use options as suggested above.

Hope this helps.

Manoj

[Former Member]

Hi,

Have a look at SAP Note 588668 - FAQ: Database statistics.

Thanks,

Sushil

[Former Member]

Hello Arvind,

While updating statistics, BRCONNECT normally:

1. Deletes statistics for certain tables, where the statistics are misleading, including pool and cluster

tables

2. Checks each table to see if the statistics are out-of-date or non-existent

3. If required, updates the statistics on the table immediately after the check

BRCONNECT uses the DBSTATC table as a control table. It performs the check and update (the final

two steps above) in a single phase.

so you dont need to check for the statistics,the job will do itself just make sure that it is scheduled weekly

Rohit

[Former Member]

Hi Arvind

UpdateStats job detail log will give you some kind of warnings of any table is remaining which is not updated or for which indexes to be rebuild, then you can use various methods to update the stats for that particular table.

however, there are the options whether the update stats is scheduled for all the tablespace tables or for some specific...

Moreover, you have to check and re-configure the DBSTATC Settings, can refer the following link:

http://help.sap.com/saphelp_nw70/helpdata/EN/df/455e8f747111d6b25100508b6b8a93/frameset.htm

As i mentioned you can select whether the update stats should run for all or for some specific table or schema, BRCONNECT options can be modified:

http://help.sap.com/saphelp_nw70/helpdata/EN/88/fce73a86e99c77e10000000a114084/frameset.htm

Like for oracle table monitoring:

http://help.sap.com/saphelp_nw70/helpdata/EN/df/01313bdffef106e10000000a11402f/content.htm

for a single table:

http://help.sap.com/saphelp_nw70/helpdata/EN/df/455e8f747111d6b25100508b6b8a93/frameset.htm

Bhudev