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).