Which three factors influence the optimizer’s behavior while choosing an optimization approach
and goal for a SQL statement? (Choose three.)
A.
parsing of a SQL statement
B.
operating system (OS) statistics
C.
object statistics in the data dictionary
D.
the OPTIMIZER_MODE initialization parameter
E.
optimizer SQL hints for changing the query optimizer goal
A is wrong. parsing does not influence optimizer behavior
B is wrong. OS stats does NOT
C is right. table stats
D is right. optimization_mode
E is right. hint
So C.D.E are correct