Which three factors influence the optimizer’s choice of an execution plan?
A.
the optimizer_mode initialization parameter
B.
type of connection used to connect to database instance
C.
cardinality estimates
D.
object statistics in the data dictionary
E.
fixed baselines
The correct answers are A, D, and E.
– https://docs.oracle.com/database/121/TGSQL/tgsql_influence.htm#TGSQL250