After an Automatic Database Diagnostic Monitor (ADDM) run, you receive a recommendation for buffer busy wait issue. View the Exhibit.
What is the significance of the Benefit(%) column in the Exhibit?
A.
It produces better query plans if the recommendation is implemented.
B.
It gives the maximum reduction in the number of input/output (I/O) operations.
C.
It gives the maximum reduction in resource usage if the recommendation is implemented.
D.
It gives the maximum reduction in database elapsed time if the recommendation is implemented.
D AB makes no sense and D is better as C as ‘was consuming significant database time’ directly relates to the answer D.