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 http://www.sybase.com/detail?id=1056206.
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 www.sypron.nl/ttr/updates_ed2.html