A file named db2advise.in contains the text shown below:
–#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname=’HAAS’;
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?

A.
Executes the first SOL statement in the workload file 100 times.

B.
Executes up to 100 combinations of optimizations for both SQL statements
in the workload file

C.
Executes both SQL statements in the workload file 100 times.

D.
Executes an index analysis for the first SQL statement in the workload
file 100 times.