Chapter 2: System Changes in Adaptive Server Version 15.0
New set command
options
Table 2-5 summarizes
the new options for the set command.
Table 2-5: New set command options
set Option
Description
set
delayed_commit
Allows you to determine
when log records are written to disk. With the delayed_commit parameter
set to true, the log records are asynchronously written to the disk
and control is returned to the client without waiting for the IO
to complete
set plan optgoal
Sets the optimization goals at the session
level.
set plan opttimeoutlimit
Sets the limit the time taken by long-running
and complex queries at the session level.
