How to create statistics for INDEX thru GUI

[pr_srinivas]

In DB13 i see messages MISSING_STATISTICS for some indexes.

I manage for tables thru DB20. How can i create statistsics for INDEX.

Rgds

PR

[stefan_koehler · Accepted solution]

Hello PR,

at first let's say you should use the BRTools to create statistics for the indexes, because of the sample method (estimate, compute) - SAP has an algorithm to choose the right sample size.

Have a look at here:

http://help.sap.com/saphelp_nw70/helpdata/en/f4/81e93a637bfd70e10000000a11402f/content.htm

If you want to create statistics manually out of the R/3 ... you can use the report "RSANAORA"

Transaction SE38 -> Report RSANAORA -> Choose your index and sample method... and go on.

Regards

Stefan

[former_member204746]

what kind of SAP system are you using?

If this is BW, run checkdB only when no loads are being done.

if not BW, go into SE14 to create index.

what are these missing indexes names?