Results
The database administrator looks at the monitoring report generated here, to check, if the statements
which were expensive are performing as expected now.
The database administrator monitors the metrics again and finds
- ROWS_READ/ROWS_RETURNED : Is normal / as expected now.
- Total sorts and other sort metrics : Is normal.
The evidence suggests that the statements which were slow earlier, due to
scanning table rows rather than using an index, perform as expected with "index scans" taking place.