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
答案解析:有
微信扫一扫手机做题