Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQLAccess Advisor?

Which two statements we true regarding the index creation recommendations given by SQL
Tuning Advisor and SQLAccess Advisor? (Choose two.)

Which two statements we true regarding the index creation recommendations given by SQL
Tuning Advisor and SQLAccess Advisor? (Choose two.)

A.
SQLTuning Advisor considers the impact of the indexes only queries.

B.
SQLTuning Advisor considers the impact of new indexes on both queries and DML operations.

C.
SQLTuning Advisor considers the impact of the newindexeson both queries and DML
operations.

D.
SQLTuning Advisor considers the impact of the indexes on only data manipulation
language(DML) operations.

Explanation:



Leave a Reply 0

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