试题详情
单项选择题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 SQL Tuning Advisor on top SQL statements

C、run the Automatic Workload Repository (AWR) report

D、run the Automatic Database Diagnostic Monitor (ADDM)on top SQL statements

  • B
  • 关注下方微信公众号,在线模考后查看

热门试题