Which action is taken by the optimizer?

Examine the parameters set for your database instance:

You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in
the SQL Plan Management Base.
Which action is taken by the optimizer? (Choose the best answer.)

Examine the parameters set for your database instance:

You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in
the SQL Plan Management Base.
Which action is taken by the optimizer? (Choose the best answer.)

A.
It adds the newly generated plan as an accepted but non-fixed plan.

B.
It adds the newly generated plan as enabled and accepted.

C.
It adds the newly generated plan as enabled but not accepted.

D.
It adds the newly generated plan as a fixed plan, which will be used each time the SQL statement is
executed.



Leave a Reply 0

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