试题详情
多项选择题What happens when you run the SQL Tuning Advisor with limited scope?()

A、Access path analysis is not performed for SQL statements.

B、SQL structure analysis is not performed for SQL statements.

C、SQL Profile recommendations are not generated for SQL statements.

D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

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

热门试题