Sybase Adaptive Server Enterprise includes a sophisticated query optimizer that analyzes statistics from queried tables, using advanced algorithms to provide better performance. Adaptive Server 15.0.3 ESD #1 and later include tools that support more effective use of Adaptive Server 15.0’s advanced query optimizer.
This book discusses optimization goals and recommendations for upgrading from Adaptive Server 12.5 to Adaptive Server 15, analyzing performance differences between the two versions, and tuning Adaptive Server 15.0 installations.
This book also documents a tool called QPTune, which enables users to identify and apply the best query plan, optimization goals, and other configuration settings.
