Query processing tips

Adaptive Server 15.0 offers a greatly improved query processing environment. However, if query plans or query performance are not what you expect, here are some ways to isolate the problem:

Obsolete optimization commands in Adaptive Server 15.0

Various optimization-related settings from 12.x are no longer relevant in Adaptive Server 15.0. Although the following commands still exist in Adaptive Server 15.0, they are relevant only in compatibility mode, and do not have any effect on the Adaptive Server 15.0 optimization process:

Sybase recommends that you remove any references to these features from your applications.