开发者

SQL Server: Trace Flag 4135

开发者 https://www.devze.com 2023-01-29 07:07 出处:网络
What is the Trace Flag 4135 in SQL Server and what i开发者_开发问答s the purpose of this flage? Should it be enabled? How to enable it?From this answer on serverfault:

What is the Trace Flag 4135 in SQL Server and what i开发者_开发问答s the purpose of this flage? Should it be enabled? How to enable it?


From this answer on serverfault:

The traceflag disables an optimization in the query optimizer. The optimization caused the issue described in the KB article when you try to insert into a table by selecting from the table itself. As turning on the traceflag could result in a perf degradation, you only should use it if you run into the issue described in the KB article.

KB Article
Thread on the topic

0

精彩评论

暂无评论...
验证码 换一张
取 消