Identify the two actions that you would suggest for these regressed SQL statements.

After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output.
Identify the two actions that you would suggest for these regressed SQL statements. (Choose two.)

After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output.

Identify the two actions that you would suggest for these regressed SQL statements. (Choose two.)

A.
Running SQL Access Advisor

B.
Adding them to SQL Plan Baseline

C.
Submitting them to SQL Tuning Advisor

D.
Running Automatic Database Diagnostic Monitor (ADDM)



Leave a Reply 0

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