The query processing and optimizer changes introduced in Adaptive Server release 12.0 are less extensive than those in 11.9.2, and should provide improved performance for most sites. These changes include:
Some of the changes that occurred in the 12.0 release of Adaptive Server are superseded by changes that occurred in the 15.0 release of Adaptive Server. These changes are described in What’s New in Adaptive Server.
For information on optimizer changes over recent Adaptive Server releases, see “An Introduction to Sybase Adaptive Server Enterprise’s Modern Optimizer” at http://my.sybase.com. This downloadable collection of optimizer-related articles published in the ISUG Technical Journal requires Acrobat Reader.
