View the Exhibit and examine the statistics of a SQL statement.
Which two conclusions can you draw from the statistics? (Choose two.)
A.
The SQL statement has high logical I/O.
B.
The SQL statement has high CPU usage.
C.
The SQL statement has high physical I/O.
D.
The SQL statement has long sort operations.
why not A and D?
AD because 25% CPU time of overall runtime does not mean ‘high CPI usage’
25% CPU is quite high.
Why do you think that D is correct?
A becuase of gets.
B false
C false
D because of group by in statement.