sp_compatmode

语法


sp_compatmode

示例

示例 1

检验是否可以使用完全兼容模式：


1> sp_compatmode

-----------------
Compatibility mode is enabled.
WARNING: Compatibility mode may not be used when
statement cache and literalautoparam are enabled. 
WARNING: The configuration option 'histogram tuning 
factor' is configured with value '20', which is not the 
default value in ASE 12.5. This may lead to different 
accuracy of statistics and different query plans.

(return status = 0)
1>

用法

此查询报告是否启用了 compatibility mode。如果使用 enable compatibility mode 时发生冲突，则会显示警告。