Specifies options that the optimizer should take into account
during optimization. The following table lists the valid options.
Option Meaning
ANY Indicates that the optimizer can choose any
optimization method
FAST FIRST Indicates that the optimizer can use FAST FIRST
optimization if and when appropriate
NONE Indicates that optional optimizations should not
be applied
TOTAL TIME Indicates that the optimizer can use TOTAL TIME
optimization if and when appropriate
The default is EXECUTION OPTIONS (ANY).