Programme SAP BC505CBO3 - Compute/estimate on table BC505IN for incorrect optimizer assumption

Description report bc505cbo3 first refreshes the statistics of tableBC505IN. You have to options: Estimate and Compute. Then analyzeBC505IN is performed using either estimate or compute statistics. Threeselect statements are issued on the table. After the program finishes amessage is issued.

Precondition
Run report BC505CBO1 first.

Output
No special output.

Example
Run the report twice and choose estimate as first select option,compute as second option. Compare the runtimes.