Skip to Content
0
Jun 08, 2007 at 04:23 AM

Accuracy of statistics with SAPDBA

11 Views

Hello,

Regarding the accuracy of statistics calculation.

From SAP Note 588668 FAQ: Database statistics, we know that using BRCONNECT the accuracy of statistics calculation is:

21. With what degree of accuracy does BRCONNECT create statistics?

The accuracy of new statistics depends on the size of the table:

Fewer than 10,000 rows: Exact calculation (COMPUTE)

Fewer than 100,000 rows: ESTIMATE with 30 % of the table

Fewer than 1,000,000 rows: ESTIMATE with 10 % of the table

Fewer than 10,000,000 rows: ESTIMATE with 3 % of the table

More than 10,000,000 rows: ESTIMATE with 1% of the table

Can anyone tell me the accuracy of statistics calculation with SAPDBA?

There is no particular purpose to this question. It's a question I was asked so if someone could help I would appreciate it.

Kind regards,

Peter Strauss