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.