'enable compatibility mode'

Summary information
Default value	0
Range of values	0 -1
Status	Dynamic
Display level
Required role	system administrator
Configuration group	User environment

enable compatibility mode provides an alternative query optimization and execution strategy for customers upgrading from a 12.5.x Adaptive Server. Once you have enabled compatibility mode Adaptive Server 15.0 uses a query engine similar to the one used in version 12.5.4.

sp_configure 'enable compatibility mode', [0/1]

For more information on using enable compatibility mode and query processing see the Migration Technology Guide.