Last updated: 09 March 2008
Updates for 'Tips, Tricks & Recipes for Sybase ASE' - 2nd edition
This page contains additions and updates for "Tips, Tricks & Recipes for Sybase ASE".

March 2008:
In chapter 15, sections 15.3.6 and 15.3.7 describe the scope and semantics of of session-level settings for optimization settings like 'set plan optgoal'.
The functionality described in these sections reflects the implementation until ASE 15.0.1 ESD#3. As of version 15.0.2 IR, some aspects of these commands have been changed, with additional changes in subsequent ESDs. The changed behaviour is described in a whitepaper (by a well-known author) which can be found at
If you are using session-level optimizer settings, this whitepaper is a must-read (if you don't use such settings, don't bother, unless you're interested).

 This document is located at