Which three factors influence the optimizer’s behavior while choosing an optimization approach and goal for a SQL statement?

Which three factors influence the optimizer’s behavior while choosing an optimization approach
and goal for a SQL statement? (Choose three.)

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



Leave a Reply 1

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


L. Zhu

L. Zhu

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