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 0

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