Table 2-5 summarizes the new options for the set command.
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. |
set metrics_capture on/off |
Activates QP metrics at the session level. |
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |