Which two statements are true regarding the activities performed during the test execution of SQL statement in a SQL Tuning Set?

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test

database. Which two statements are true regarding the activities performed during the test
execution of SQL statement in a SQL Tuning Set? (Choose two.)

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test

database. Which two statements are true regarding the activities performed during the test
execution of SQL statement in a SQL Tuning Set? (Choose two.)

A.
The effects of DDL and DML are considered to produce the execution plan and execution
statistics.

B.
The execution plan and execution statistics are computed for each SQL statement in the

C.
Every SQL statement in the STS is considered only once for execution.

D.
The SQL statements in the STS are executed concurrently to produce the execution plan
and execution statistics.



Leave a Reply 0

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