MISSING_STATISTICS, object: (table)

[Former Member]

Hi expert,

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPSR3.ZVENDOR_PAYMENT1

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPSR3.ZVENDOR_PAYMENT1~0

Please do the neefull.

can i create new STATISTICS via DB20 TX.

Regards

[former_member199632]

Hello vivek,

You can also schedule db13 UpdateStats job. (Check and update optimizer statistics)

It will update the table stats

regards,

Zerandib.

[Former Member]

done

[Former Member]

k

[Former Member]

yes Vivek, you can either use DB20 or BRTools for collecting the statistics for specific tables.

Also, read the SAP notes 838725 and 588668 to know more about statistics.

Br,

Venky

[Former Member]

can i create the STATISTICS Via DB20??

[Former Member]

yes, you can create the statistics using DB20.

Br,

Venky

[Former Member]

Its my PRD system any issue may be accure???

[Former Member]

Hi Vivek,

No, this will not cause any performance impact. The statistics creation runtime depends on the size of the table.

Br,

Venky