Which three factors influence the optimizer’s choice of…

Which three factors influence the optimizer’s choice of an execution plan?

Which three factors influence the optimizer’s choice of an execution plan?

A.
the optimizer_mode initialization parameter

B.
operating system (OS) statistics

C.
cardinality estimates

D.
object statistics in the data dictionary

E.
fixed baselines

Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14211/optimops.htm



Leave a Reply 0

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