A new fake table sysoptions and a new stored procedure sp_options let you view optimizer settings.
To let you easily view optimizer settings, Adaptive Server
version 15.0.2 introduces:
-
sysoptions – a
new fake table that stores information about each set option,
its category, and its current and default settings. sysoptions also contains
a bitmap containing further detailed information about the option.
-
sp_options – a
new stored procedure that shows option values.