The query processing and optimizer changes introduced in ASE 12.0 are less extensive than those in 11.9.2, and should provide improved performance for most sites. These changes include the following:
For information on optimizer changes over recent ASE releases, see also the collection An Introduction to Sybase Adaptive Server Enterprise’s Modern Optimizer. This downloadable collection of optimizer-related articles published in the ISUG Technical Journal requires Acrobat Reader.