Ansicht
Dokumentation

BC505CBO2 - Compute/estimate on table BC505IN to demonstrate low precision problem

Description

Report BC505CBO2 first refreshes the statistics of table BC505IN. You

have to options: Estimate and Compute. Then analyze BC505IN is performed using either estimate or compute statistics. Three select statements are issued on the table. After the program finishes a message is issued.

Requirements

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.