Sample size in Report RSANAORA

[Former Member]

Hi Team ,

I am supposed to update stats on a table . I am using report  RSANAORA to update the stats.

Could you please explain how exactly the Sample Size  values is  used for calculation of stats statistics.?

If I am choosing 10% , does it mean only 10% of table rows will be used to calculate stats of

complete table .

Regards ,

Abhinav

[former_member188883 · Accepted solution]

Hi Abhinav,

Please refer SAP link

http://help.sap.com/saphelp_nw73/helpdata/en/c4/bb5283cf8848d78c5c2b171173a3ad/content.htm

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thanks Deepak .

But I am seeking what does exactly it mean to have 10% sample space.

If I am choosing 10% , does it mean only 10% of table rows will be used to calculate stats of

complete table  or this means something else.

[former_member188883 · Accepted solution]

Hi Abhinav,

From the SAP link shared earlier, brtools chooses following standard calculation

For 10%  Number of rows selected would be

100,000 - 999,999

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Abhinav,

To understand how exactly this sampling works .. Please go through the below documentation.

http://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm

THanks,

Jagadish.