What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?

A.
run Segment Advisor

B.
run the Automatic Workload Repository (AWR) report

C.
run the Automatic Database Diagnostic Monitor (ADDM) on top SQL statements

D.
run SQL Tuning Advisor on top SQL statements



Leave a Reply 0

Your email address will not be published. Required fields are marked *